data-cleaning. See also theR-universe documentation.Package: dcmodifydb 0.3.1
dcmodifydb: Modifying Rules on a DataBase
Apply modification rules from R package 'dcmodify' to the database, prescribing and documenting deterministic data cleaning steps on records in a database. The rules are translated into SQL statements using R package 'dbplyr'.
Authors:
dcmodifydb_0.3.1.tar.gz
dcmodifydb_0.3.1.zip(r-4.5)dcmodifydb_0.3.1.zip(r-4.4)dcmodifydb_0.3.1.zip(r-4.3)
dcmodifydb_0.3.1.tgz(r-4.4-any)dcmodifydb_0.3.1.tgz(r-4.3-any)
dcmodifydb_0.3.1.tar.gz(r-4.5-noble)dcmodifydb_0.3.1.tar.gz(r-4.4-noble)
dcmodifydb_0.3.1.tgz(r-4.4-emscripten)dcmodifydb_0.3.1.tgz(r-4.3-emscripten)
dcmodifydb.pdf |dcmodifydb.html✨
dcmodifydb/json (API)
NEWS
| # Install 'dcmodifydb' in R: |
| install.packages('dcmodifydb', repos = c('https://edwindj.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/data-cleaning/dcmodifydb/issues
- person - Person data, income and smoking habits
correctiondata-cleaningdatabase
Last updated 3 years agofrom:dd34c40ebe. Checks:ERROR: 7. Indexed: no.
| Target | Result | Date |
|---|---|---|
| Doc / Vignettes | FAIL | Dec 16 2024 |
| R-4.5-win | ERROR | Dec 16 2024 |
| R-4.5-linux | ERROR | Dec 16 2024 |
| R-4.4-win | ERROR | Dec 16 2024 |
| R-4.4-mac | ERROR | Dec 16 2024 |
| R-4.3-win | ERROR | Dec 16 2024 |
| R-4.3-mac | ERROR | Dec 16 2024 |
Exports:dump_sqlis_working_dbmodifier_to_sqlmodify
Dependencies:blobclicpp11DBIdbplyrdcmodifydplyrfansigenericsgluelifecyclelumberjackmagrittrpillarpkgconfigpurrrR6rlangsettingsstringistringrtibbletidyrtidyselectutf8validatevctrswithryaml
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Show generated sql | dump_sql |
| Rule check on the database | is_working_db |
| Utility function to extract SQL statements | modifier_to_sql |
| Apply corrections/derivations to a db table | modify,ANY,modifier-method |
| Person data, income and smoking habits | person |
