Package: dfeR 1.2.0.9000

Cam Race

dfeR: Common Department for Education Analysis Tasks

Preferred methods for common analytical tasks that are undertaken across the Department, including number formatting, project templates and curated reference data.

Authors:Cam Race [aut, cre], Department for Education, England [cph], Laura Selby [aut], Adam Robinson [aut], Jen Machin [ctb], Jake Tufts [ctb], Rich Bielby [ctb], Menna Zayed [ctb], Lauren Snaathorst [ctb], Lara Garbett [ctb], Paula Rocha [ctb]

dfeR_1.2.0.9000.tar.gz
dfeR_1.2.0.9000.zip(r-4.7)dfeR_1.2.0.9000.zip(r-4.6)dfeR_1.2.0.9000.zip(r-4.5)
dfeR_1.2.0.9000.tgz(r-4.6-any)dfeR_1.2.0.9000.tgz(r-4.5-any)
dfeR_1.2.0.9000.tar.gz(r-4.7-any)dfeR_1.2.0.9000.tar.gz(r-4.6-any)
dfeR_1.2.0.9000.tgz(r-4.6-emscripten)
manual.pdf |manual.html
DESCRIPTION |NEWS
card.svg |card.png
dfeR/json (API)

# Install 'dfeR' in R:
install.packages('dfeR', repos = c('https://dfe-analytical-services.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/dfe-analytical-services/dfer/issues

Pkgdown/docs site:https://dfe-analytical-services.github.io

Datasets:

On CRAN:

Conda:

7.62 score 14 stars 13 scripts 343 downloads 27 exports 53 dependencies

Last updated from:8d62b77376. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK176
source / vignettesOK218
linux-release-x86_64OK177
macos-release-arm64OK177
macos-oldrel-arm64OK133
windows-develOK228
windows-releaseOK194
windows-oldrelOK192
wasm-releaseOK127

Exports:air_installair_stylecheck_databricks_odbccomma_sepcreate_projectfetch_countriesfetch_ladsfetch_lasfetch_mayoralfetch_pconsfetch_regionsfetch_wardsformat_ayformat_ay_reverseformat_fyformat_fy_reverseget_clean_sqlget_ons_api_datapretty_filesizepretty_numpretty_num_tablepretty_timepretty_time_takenround_five_uptoggle_messagewrite_df_to_deltaz_replace

Dependencies:arrowaskpassassertthatbitbit64clicliprcpp11crayoncredentialscurlDBIdescdplyremojifsgenericsgertgitcredsgluehttrhttr2inijsonlitelifecyclemagrittrmimeopensslpillarpkgconfigpurrrR6rappdirsrenvrlangrprojrootrstudio.prefsrstudioapirvestselectrstringistringrsystibbletidyselectusethisutf8vctrswhiskerwithrxml2yamlzip

Scalable Bulk Writing to Databricks: write_df_to_delta
Executive Summary | Why this is a game-changer for your workflow: | Under the Hood: The REST API Advantage | Prerequisites: Permissions and Authentication | Databricks Permissions | R Session Configuration | Basic Usage | What happens during execution? | Advanced Usage | Precise Data Type Mapping (Arrow Schemas) | Manual Chunking for Memory Management | Overwriting vs. Appending | Performance Benchmarks | Methodology | Key Results | Recommendation: Choosing the Right Tool | Stress Tests | The "Safety Net": Resilience at Scale | Key Results and Observations | Troubleshooting

Last update: 2026-02-19
Started: 2026-02-19

Creating a new dfeR project
Introduction and prerequisites | Prerequisites | What is RStudio? | How do I install dfeR? | What is an R project? | What is renv? | What is testthat? | What is a GitHub .gitignore file? | Using the create_project() function | Where to save your project | Parameters | Creating a project using code | Example use | Creating a project using the 'New Project Wizard' | Troubleshooting

Last update: 2025-05-19
Started: 2025-05-19

Connecting to SQL
Pre-requisites | Connecting to a database | Reading a SQL script into R | Executing the SQL query | Troubleshooting

Last update: 2024-09-26
Started: 2024-03-27

Readme and manuals

Help Manual

Help pageTopics
Air Installair_install
Air - style code in scriptsair_style
Check Databricks ODBC connection variablescheck_databricks_odbc
Comma separatecomma_sep
Lookup for valid country names and codescountries
Creates a pre-populated project for DfE Rcreate_project
Fetch Westminster parliamentary constituenciesfetch fetch_pcons
Fetch countriesfetch_countries
Fetch local authority districtsfetch_lads
Fetch local authoritiesfetch_las
Fetch mayoral combined authoritiesfetch_mayoral
Fetch regionsfetch_regions
Fetch wardsfetch_wards
Format academic yearformat_ay
Undo academic year formattingformat_ay_reverse
Format financial yearformat_fy
Undo financial year formattingformat_fy_reverse
Geography hierarchy lookupgeo_hierarchy
Potential names for geography and time columnsgeog_time_identifiers
Get a cleaned SQL script into Rget_clean_sql
Fetch ONS Open Geography API dataget_ons_api_data
Lookup for ONS geography columns shorthandsons_geog_shorthands
Pretty numbers into readable file sizepretty_filesize
Prettify big numbers into a readable formatpretty_num
Format a data frame with 'dfeR::pretty_num()'.pretty_num_table
Pretty timepretty_time
Calculate elapsed time between two points and present prettilypretty_time_taken
Lookup for valid region names and codesregions
Round five upround_five_up
Controllable console messagestoggle_message
Ward to Constituency to LAD to LA to Region to Country lookupwd_pcon_lad_la_rgn_ctry
Write a Data Frame to Delta Lake with COPY INTOwrite_df_to_delta
Replaces 'NA' values in tablesz_replace