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 2 years agofrom:dd34c40ebe. Checks:ERROR: 7. Indexed: no.
Target | Result | Date |
---|---|---|
Doc / Vignettes | FAIL | Nov 16 2024 |
R-4.5-win | ERROR | Nov 16 2024 |
R-4.5-linux | ERROR | Nov 16 2024 |
R-4.4-win | ERROR | Nov 16 2024 |
R-4.4-mac | ERROR | Nov 16 2024 |
R-4.3-win | ERROR | Nov 16 2024 |
R-4.3-mac | ERROR | Nov 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 |