data-cleaning. To fix this you can add URL: https://edwindj.r-universe.dev/dcmodifydb to the package DESCRIPTION file. 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.7)dcmodifydb_0.3.1.zip(r-4.6)dcmodifydb_0.3.1.zip(r-4.5)
dcmodifydb_0.3.1.tgz(r-4.6-any)dcmodifydb_0.3.1.tgz(r-4.5-any)
dcmodifydb_0.3.1.tar.gz(r-4.7-any)dcmodifydb_0.3.1.tar.gz(r-4.6-any)
dcmodifydb_0.3.1.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
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 from:dd34c40ebe. Checks:8 ERROR, 1 OK. Indexed: no.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | ERROR | 147 | ||
| source / vignettes | ERROR | 197 | ||
| linux-release-x86_64 | ERROR | 150 | ||
| macos-release-arm64 | ERROR | 92 | ||
| macos-oldrel-arm64 | ERROR | 80 | ||
| windows-devel | ERROR | 93 | ||
| windows-release | ERROR | 399 | ||
| windows-oldrel | ERROR | 90 | ||
| wasm-release | OK | 106 |
Exports:dump_sqlis_working_dbmodifier_to_sqlmodify
Dependencies:blobclicpp11DBIdbplyrdcmodifydplyrgenericsgluelifecyclelumberjackmagrittrpillarpkgconfigpurrrR6rlangsettingsstringistringrtibbletidyrtidyselectutf8validatevctrswithryaml
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 |
