{ "_id": "6a1ed793b401979e7340ee36", "Type": "Package", "Package": "dfeR", "Title": "Common Department for Education Analysis Tasks", "Version": "1.2.0.9000", "Authors@R": "c(\nperson(\"Cam\", \"Race\", , \"cameron.race@education.gov.uk\", role = c(\"aut\", \"cre\")),\nperson(\"Department for Education, England\", , , \"statistics.development@education.gov.uk\", role = \"cph\"),\nperson(\"Laura\", \"Selby\", , \"laura.selby@education.gov.uk\", role = \"aut\"),\nperson(\"Adam\", \"Robinson\", role = \"aut\"),\nperson(\"Jen\", \"Machin\", , \"jen.machin@education.gov.uk\", role = \"ctb\"),\nperson(\"Jake\", \"Tufts\", , \"jake.tufts@education.gov.uk\", role = \"ctb\"),\nperson(\"Rich\", \"Bielby\", , \"richard.bielby@education.gov.uk\", role = \"ctb\",\ncomment = c(ORCID = \"0000-0001-9070-9969\")),\nperson(\"Menna\", \"Zayed\", , \"menna.zayed@education.gov.uk\", role = \"ctb\"),\nperson(\"Lauren\", \"Snaathorst\", , \"lauren.snaathorst@education.gov.uk\", role = \"ctb\"),\nperson(\"Lara\", \"Garbett\", , \"lara.garbett@education.gov.uk\", role = \"ctb\"),\nperson(\"Paula\", \"Rocha\", , \"paula.rocha@education.gov.uk\", role = \"ctb\")\n)", "Description": "Preferred methods for common analytical tasks that are\nundertaken across the Department, including number formatting,\nproject templates and curated reference data.", "License": "GPL (>= 3)", "URL": "https://dfe-analytical-services.github.io/dfeR/,\nhttps://github.com/dfe-analytical-services/dfeR", "BugReports": "https://github.com/dfe-analytical-services/dfeR/issues", "VignetteBuilder": "knitr", "Config/testthat/edition": "3", "Encoding": "UTF-8", "Language": "en-GB", "LazyData": "true", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.3", "Config/pak/sysreqs": "cmake git make libgit2-dev libicu-dev libuv1-dev\nlibxml2-dev libssl-dev libx11-dev", "Repository": "https://dfe-analytical-services.r-universe.dev", "Date/Publication": "2026-04-20 21:22:34 UTC", "RemoteUrl": "https://github.com/dfe-analytical-services/dfer", "RemoteRef": "HEAD", "RemoteSha": "8d62b773760ffac53f9635b79d423140b2bf7860", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-20 10:01:45 UTC", "User": "root" }, "Author": "Cam Race [aut, cre],\nDepartment for Education, England [cph],\nLaura Selby [aut],\nAdam Robinson [aut],\nJen Machin [ctb],\nJake Tufts [ctb],\nRich Bielby [ctb] (ORCID: ),\nMenna Zayed [ctb],\nLauren Snaathorst [ctb],\nLara Garbett [ctb],\nPaula Rocha [ctb]", "Maintainer": "Cam Race ", "MD5sum": "6abc56943ac0e2a608ca3aa3581e09f7", "_user": "dfe-analytical-services", "_type": "src", "_file": "dfeR_1.2.0.9000.tar.gz", "_fileid": "f85850a5c2e849cb94e8c3cb67c5507287a36e0e826c1e3e0f4cdd671713770d", "_filesize": 1585836, "_sha256": "f85850a5c2e849cb94e8c3cb67c5507287a36e0e826c1e3e0f4cdd671713770d", "_created": "2026-05-20T10:01:45.000Z", "_published": "2026-06-02T13:16:03.452Z", "_distro": "noble", "_jobs": [ { "job": 79079034413, "time": 184, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7107049240" }, { "job": 79079034290, "time": 200, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7107054797" }, { "job": 79079034388, "time": 164, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7107042023" }, { "job": 79079034156, "time": 141, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7107033969" }, { "job": 79079033961, "time": 244, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7106985175" }, { "job": 79079033410, "time": 142, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7358706638" }, { "job": 79079034124, "time": 222, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7107061596" }, { "job": 79079034852, "time": 185, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7107050200" }, { "job": 79079034225, "time": 177, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7107047154" } ], "_buildurl": "https://github.com/r-universe/dfe-analytical-services/actions/runs/26155285036", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/dfe-analytical-services/dfer", "_commit": { "id": "8d62b773760ffac53f9635b79d423140b2bf7860", "author": "cjrace <52536248+cjrace@users.noreply.github.com>", "committer": "cjrace <52536248+cjrace@users.noreply.github.com>", "message": "Quick contributing docs fix\n", "time": 1776720154 }, "_maintainer": { "name": "Cam Race", "email": "cameron.race@education.gov.uk", "login": "cjrace", "linkedin": "in/cam-race-a5048b106", "description": "", "uuid": 52536248 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "arrow", "role": "Imports" }, { "package": "cli", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "emoji", "role": "Imports" }, { "package": "httr", "role": "Imports" }, { "package": "httr2", "role": "Imports" }, { "package": "jsonlite", "role": "Imports" }, { "package": "lifecycle", "role": "Imports" }, { "package": "renv", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "rstudio.prefs", "role": "Imports" }, { "package": "tidyselect", "role": "Imports" }, { "package": "usethis", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "withr", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "readxl", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "spelling", "role": "Suggests" }, { "package": "stringr", "role": "Suggests" }, { "package": "tidyr", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "mockery", "role": "Suggests" }, { "package": "ggplot2", "role": "Suggests" }, { "package": "purrr", "role": "Suggests" }, { "package": "scales", "role": "Suggests" } ], "_owner": "dfe-analytical-services", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-21", "n": 1 }, { "week": "2025-24", "n": 1 }, { "week": "2025-34", "n": 2 }, { "week": "2025-37", "n": 1 }, { "week": "2025-38", "n": 1 }, { "week": "2025-39", "n": 1 }, { "week": "2025-40", "n": 1 }, { "week": "2025-44", "n": 1 }, { "week": "2025-47", "n": 1 }, { "week": "2025-52", "n": 2 }, { "week": "2026-02", "n": 2 }, { "week": "2026-04", "n": 1 }, { "week": "2026-05", "n": 1 }, { "week": "2026-07", "n": 1 }, { "week": "2026-08", "n": 1 }, { "week": "2026-17", "n": 1 } ], "_tags": [ { "name": "v1.1.0", "date": "2025-09-12" }, { "name": "v1.2.0", "date": "2025-09-16" } ], "_stars": 14, "_contributors": [ { "user": "cjrace", "count": 81, "uuid": 52536248 }, { "user": "adamrobinson361", "count": 21, "uuid": 20915537 }, { "user": "mzayeddfe", "count": 10, "uuid": 183516218 }, { "user": "lauraselby", "count": 3, "uuid": 31728972 }, { "user": "lsnaathorst1", "count": 2, "uuid": 149484172 }, { "user": "rocha-paula", "count": 2, "uuid": 243964000 }, { "user": "rmbielby", "count": 2, "uuid": 230859 }, { "user": "jen-machin", "count": 2, "uuid": 143802501 }, { "user": "laragarbett", "count": 2, "uuid": 227179039 }, { "user": "jt-39", "count": 1, "uuid": 137207796 }, { "user": "wklimowicz", "count": 1, "uuid": 62679873 }, { "user": "davidgoody-dfe", "count": 1, "uuid": 38499496 } ], "_userbio": { "uuid": 37449592, "type": "organization", "name": "DfE Analytical Services" }, "_downloads": { "count": 237, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dfeR" }, "_devurl": "https://github.com/dfe-analytical-services/dfer", "_pkgdown": "https://dfe-analytical-services.github.io/dfeR/", "_searchresults": 13, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/dfeR.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/dfe-analytical-services/dfer", "_realowner": "dfe-analytical-services", "_cranurl": true, "_releases": [ { "version": "1.0.0", "date": "2025-01-13" }, { "version": "1.0.1", "date": "2025-01-17" } ], "_exports": [ "air_install", "air_style", "check_databricks_odbc", "comma_sep", "create_project", "fetch_countries", "fetch_lads", "fetch_las", "fetch_mayoral", "fetch_pcons", "fetch_regions", "fetch_wards", "format_ay", "format_ay_reverse", "format_fy", "format_fy_reverse", "get_clean_sql", "get_ons_api_data", "pretty_filesize", "pretty_num", "pretty_num_table", "pretty_time", "pretty_time_taken", "round_five_up", "toggle_message", "write_df_to_delta", "z_replace" ], "_datasets": [ { "name": "countries", "title": "Lookup for valid country names and codes", "object": "countries", "class": [ "data.frame" ], "fields": [ "country_code", "country_name" ], "rows": 10, "table": true, "tojson": true }, { "name": "geo_hierarchy", "title": "Geography hierarchy lookup", "object": "geo_hierarchy", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "first_available_year_included", "most_recent_year_included", "ward_name", "pcon_name", "lad_name", "la_name", "english_devolved_area_name", "region_name", "country_name", "ward_code", "pcon_code", "lad_code", "old_la_code", "new_la_code", "english_devolved_area_code", "region_code", "country_code" ], "rows": 26057, "table": true, "tojson": true }, { "name": "geog_time_identifiers", "title": "Potential names for geography and time columns", "object": "geog_time_identifiers", "class": [ "character" ], "fields": [], "table": false, "tojson": true }, { "name": "ons_geog_shorthands", "title": "Lookup for ONS geography columns shorthands", "object": "ons_geog_shorthands", "class": [ "data.frame" ], "fields": [ "ons_level_shorthands", "name_column", "code_column" ], "rows": 9, "table": true, "tojson": true }, { "name": "regions", "title": "Lookup for valid region names and codes", "object": "regions", "class": [ "data.frame" ], "fields": [ "region_code", "region_name" ], "rows": 16, "table": true, "tojson": true }, { "name": "wd_pcon_lad_la_rgn_ctry", "title": "Ward to Constituency to LAD to LA to Region to Country lookup", "object": "wd_pcon_lad_la_rgn_ctry", "class": [ "data.frame" ], "fields": [ "first_available_year_included", "most_recent_year_included", "ward_name", "pcon_name", "lad_name", "la_name", "region_name", "country_name", "ward_code", "pcon_code", "lad_code", "old_la_code", "new_la_code", "region_code", "country_code" ], "rows": 24629, "table": true, "tojson": true } ], "_help": [ { "page": "air_install", "title": "Air Install", "topics": [ "air_install" ] }, { "page": "air_style", "title": "Air - style code in scripts", "topics": [ "air_style" ] }, { "page": "check_databricks_odbc", "title": "Check Databricks ODBC connection variables", "concept": [ "databricks" ], "topics": [ "check_databricks_odbc" ] }, { "page": "comma_sep", "title": "Comma separate", "topics": [ "comma_sep" ] }, { "page": "countries", "title": "Lookup for valid country names and codes", "topics": [ "countries" ] }, { "page": "create_project", "title": "Creates a pre-populated project for DfE R", "topics": [ "create_project" ] }, { "page": "fetch", "title": "Fetch Westminster parliamentary constituencies", "topics": [ "fetch", "fetch_pcons" ] }, { "page": "fetch_countries", "title": "Fetch countries", "concept": [ "fetch_locations" ], "topics": [ "fetch_countries" ] }, { "page": "fetch_lads", "title": "Fetch local authority districts", "concept": [ "fetch_locations" ], "topics": [ "fetch_lads" ] }, { "page": "fetch_las", "title": "Fetch local authorities", "concept": [ "fetch_locations" ], "topics": [ "fetch_las" ] }, { "page": "fetch_mayoral", "title": "Fetch mayoral combined authorities", "concept": [ "fetch_locations" ], "topics": [ "fetch_mayoral" ] }, { "page": "fetch_regions", "title": "Fetch regions", "concept": [ "fetch_locations" ], "topics": [ "fetch_regions" ] }, { "page": "fetch_wards", "title": "Fetch wards", "concept": [ "fetch_locations" ], "topics": [ "fetch_wards" ] }, { "page": "format_ay", "title": "Format academic year", "concept": [ "format" ], "topics": [ "format_ay" ] }, { "page": "format_ay_reverse", "title": "Undo academic year formatting", "concept": [ "format" ], "topics": [ "format_ay_reverse" ] }, { "page": "format_fy", "title": "Format financial year", "concept": [ "format" ], "topics": [ "format_fy" ] }, { "page": "format_fy_reverse", "title": "Undo financial year formatting", "concept": [ "format" ], "topics": [ "format_fy_reverse" ] }, { "page": "geo_hierarchy", "title": "Geography hierarchy lookup", "topics": [ "geo_hierarchy" ] }, { "page": "geog_time_identifiers", "title": "Potential names for geography and time columns", "topics": [ "geog_time_identifiers" ] }, { "page": "get_clean_sql", "title": "Get a cleaned SQL script into R", "topics": [ "get_clean_sql" ] }, { "page": "get_ons_api_data", "title": "Fetch ONS Open Geography API data", "topics": [ "get_ons_api_data" ] }, { "page": "ons_geog_shorthands", "title": "Lookup for ONS geography columns shorthands", "topics": [ "ons_geog_shorthands" ] }, { "page": "pretty_filesize", "title": "Pretty numbers into readable file size", "concept": [ "prettying" ], "topics": [ "pretty_filesize" ] }, { "page": "pretty_num", "title": "Prettify big numbers into a readable format", "concept": [ "prettying" ], "topics": [ "pretty_num" ] }, { "page": "pretty_num_table", "title": "Format a data frame with 'dfeR::pretty_num()'.", "concept": [ "prettying" ], "topics": [ "pretty_num_table" ] }, { "page": "pretty_time", "title": "Pretty time", "concept": [ "prettying" ], "topics": [ "pretty_time" ] }, { "page": "pretty_time_taken", "title": "Calculate elapsed time between two points and present prettily", "concept": [ "prettying" ], "topics": [ "pretty_time_taken" ] }, { "page": "regions", "title": "Lookup for valid region names and codes", "topics": [ "regions" ] }, { "page": "round_five_up", "title": "Round five up", "topics": [ "round_five_up" ] }, { "page": "toggle_message", "title": "Controllable console messages", "topics": [ "toggle_message" ] }, { "page": "wd_pcon_lad_la_rgn_ctry", "title": "Ward to Constituency to LAD to LA to Region to Country lookup", "topics": [ "wd_pcon_lad_la_rgn_ctry" ] }, { "page": "write_df_to_delta", "title": "Write a Data Frame to Delta Lake with COPY INTO", "concept": [ "databricks" ], "topics": [ "write_df_to_delta" ] }, { "page": "z_replace", "title": "Replaces 'NA' values in tables", "topics": [ "z_replace" ] } ], "_pkglogo": "https://github.com/dfe-analytical-services/dfer/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/dfe-analytical-services/dfer/raw/HEAD/README.md", "_rundeps": [ "arrow", "askpass", "assertthat", "bit", "bit64", "cli", "clipr", "cpp11", "crayon", "credentials", "curl", "DBI", "desc", "dplyr", "emoji", "fs", "generics", "gert", "gh", "gitcreds", "glue", "httr", "httr2", "ini", "jsonlite", "lifecycle", "magrittr", "mime", "openssl", "pillar", "pkgconfig", "purrr", "R6", "rappdirs", "renv", "rlang", "rprojroot", "rstudio.prefs", "rstudioapi", "rvest", "selectr", "stringi", "stringr", "sys", "tibble", "tidyselect", "usethis", "utf8", "vctrs", "whisker", "withr", "xml2", "yaml", "zip" ], "_vignettes": [ { "source": "connecting_to_sql.Rmd", "filename": "connecting_to_sql.html", "title": "Connecting to SQL", "engine": "knitr::rmarkdown", "headings": [ "Pre-requisites", "Connecting to a database", "Reading a SQL script into R", "Executing the SQL query", "Troubleshooting" ], "created": "2024-03-27 10:38:46", "modified": "2024-09-26 13:19:03", "commits": 3 }, { "source": "create_new_project.Rmd", "filename": "create_new_project.html", "title": "Creating a new dfeR project", "engine": "knitr::rmarkdown", "headings": [ "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" ], "created": "2025-05-19 10:00:12", "modified": "2025-05-19 10:00:12", "commits": 1 }, { "source": "write_df_to_delta.Rmd", "filename": "write_df_to_delta.html", "title": "Scalable Bulk Writing to Databricks: write_df_to_delta", "engine": "knitr::rmarkdown", "headings": [ "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" ], "created": "2026-02-19 12:02:54", "modified": "2026-02-19 12:02:54", "commits": 1 } ], "_score": 7.681675314854907, "_indexed": true, "_nocasepkg": "dfer", "_universes": [ "dfe-analytical-services", "cjrace" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.2.0.9000", "date": "2026-05-20T10:04:30.000Z", "distro": "noble", "commit": "8d62b773760ffac53f9635b79d423140b2bf7860", "fileid": "a366cd5dd3b045ea78252fb46f4464505695ad8945eaa064eae0c99d8deb5bbe", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dfe-analytical-services/actions/runs/26155285036" }, { "r": "4.6.0", "os": "linux", "version": "1.2.0.9000", "date": "2026-05-20T10:04:47.000Z", "distro": "noble", "commit": "8d62b773760ffac53f9635b79d423140b2bf7860", "fileid": "536dc7ebf49c289ee4ebfd7eda075bf63f3acf94152a77c257237ed7894de264", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dfe-analytical-services/actions/runs/26155285036" }, { "r": "4.5.3", "os": "mac", "version": "1.2.0.9000", "date": "2026-05-20T10:04:06.000Z", "commit": "8d62b773760ffac53f9635b79d423140b2bf7860", "fileid": "a9ff40508d69b924fd0d089b69dc2c0e5d1880f2eb815abf3146194035be4e1e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dfe-analytical-services/actions/runs/26155285036" }, { "r": "4.6.0", "os": "mac", "version": "1.2.0.9000", "date": "2026-05-20T10:03:56.000Z", "commit": "8d62b773760ffac53f9635b79d423140b2bf7860", "fileid": "0ce19b2e1573bc13e315d8ab78af8742512652c39336e52005a8abfd1ad56ed3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dfe-analytical-services/actions/runs/26155285036" }, { "r": "4.7.0", "os": "win", "version": "1.2.0.9000", "date": "2026-05-20T10:04:16.000Z", "commit": "8d62b773760ffac53f9635b79d423140b2bf7860", "fileid": "61fb8360e607eed7207cdd59d9ce544711d14de1ab1171d99abdf9ccd8678e91", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dfe-analytical-services/actions/runs/26155285036" }, { "r": "4.5.3", "os": "win", "version": "1.2.0.9000", "date": "2026-05-20T10:03:47.000Z", "commit": "8d62b773760ffac53f9635b79d423140b2bf7860", "fileid": "aa59c4cbbcab1ed379f3239d5b24806cfe2cbc6b5406f0553e6992613c411b57", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dfe-analytical-services/actions/runs/26155285036" }, { "r": "4.6.0", "os": "win", "version": "1.2.0.9000", "date": "2026-05-20T10:03:35.000Z", "commit": "8d62b773760ffac53f9635b79d423140b2bf7860", "fileid": "6b40a629eb84608eaaa3e7a67e13de631c21eddf08da1d58ab54a0d445d8bf4e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dfe-analytical-services/actions/runs/26155285036" }, { "r": "4.6.0", "os": "wasm", "version": "1.2.0.9000", "date": "2026-06-02T13:15:16.000Z", "commit": "8d62b773760ffac53f9635b79d423140b2bf7860", "fileid": "7846adcf12ca2430f90918724001b85eda668f43d09919c6ebf906b0f01e3ad4", "status": "success", "buildurl": "https://github.com/r-universe/dfe-analytical-services/actions/runs/26155285036" } ] }