NEWS

---

dfeR 1.2.0.9000

• Updated geo_hierarchy, and associated fetch_* functions with latest 2025 lookups.
• Updated pretty_num() function to add abbreviate argument giving the option to avoid displaying large numbers in millions/billions.

dfeR 1.2.0

• Added geo_hierarchy, which supersedes wd_pcon_lad_la_rgn_ctry and adds 2025 along with mayoral columns.
• Added fetch_mayoral().

dfeR 1.1.0

• Added a function that checks Databricks variables for ODBC connections: check_databricks_odbc().
• Updated wd_pcon_lad_la_rgn_ctry by adding three digit local authority codes (also known as old_la_codes) to the data.
• Added old_la_codes which is an internal lookup table of local authorities with their names, nine digit codes and 'old' three digit codes. It is used to add 'old' 3 digit la codes to wd_pcon_lad_la_rgn_ctry.
• Updated fetch_las() so that old_la_codes are included in the output.

dfeR 1.0.1 (2025-01-15)

Fix the spacing and printing of the z_replace() warning message, updating the eesyapi URL in the README and removed extraneous package tests.

dfeR 1.0.0 (2025-01-13)

Initial CRAN release. Added lookup data geog_time_identifiers. Added z_replace() to replace NA values in tables except for ones in geography and time columns that match ones in geog_time_identifiers.

dfeR 0.6.1

Patch to update the pretty_num() function so that the dp argument's default is 0.

dfeR 0.6.0

Update pretty_num so that:

• it can take single or multiple values.
• it has the argument nsmall that allows control over the number of digits displayed after rounding.

Add pretty_num_table() which uses pretty_num() to format numbers in a readable format in data frames. It has all the customization provided by pretty_num.

dfeR 0.5.1

Patch to update the get_clean_sql() function to ignore lines starting with 'USE'.

dfeR 0.5.0

Add the following lookup data sets into the package:

• ons_geog_shorthands
• countries
• regions
• wd_pcon_lad_la_rgn_ctry

Add the following fetch_locations() functions:

• fetch_wards()
• fetch_pcons()
• fetch_lads()
• fetch_las()
• fetch_regions()
• fetch_countries()

Add wrapper for ONS Open Geography Portal API:

• get_ons_api_data()

Add helper for turning messages on or off:

• toggle_message()

dfeR 0.4.1

Update comma_sep() function to allow non-numeric values instead of throwing an error, now returns them unchanged.

dfeR 0.4.0

Add function which creates a DfE R project:

• create_project()

dfeR 0.3.1

Fix bug in get_clean_sql() where using the additional settings would lose the original SQL statement.

dfeR 0.3.0

Add pretty_* functions for presenting pretty numbers:

• pretty_num()
• pretty_filesize()
• pretty_time_taken()

Add helper function for comma separating numbers:

• comma_sep()

dfeR 0.2.0

Add function for formatting financial years:

• format_fy()

Add reversing functions for academic and financial years:

• format_ay_reverse()
• format_fy_reverse()

Add function for grabbing and cleaning a SQL script, and vignette for connecting to SQL.

• get_clean_sql()

dfeR 0.1.1

Add default value to decimal place argument of round_five_up() function.

dfeR 0.1.0

Relaunch of the package with two functions:

• format_ay()
• round_five_up()