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:Edwin de Jonge [aut, cre], Wytze Gelderloos [ctb]

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

Datasets:

person - Person data, income and smoking habits

On CRAN:

correction data-cleaning database

4 exports 5 stars 0.71 score 29 dependencies 26 downloads

Last updated 2 years agofrom:dd34c40ebe

Exports:dump_sql is_working_db modifier_to_sql modify

Dependencies:blob cli cpp11 DBI dbplyr dcmodify dplyr fansi generics glue lifecycle lumberjack magrittr pillar pkgconfig purrr R6 rlang settings stringi stringr tibble tidyr tidyselect utf8 validate vctrs withr yaml

Vignettes and/or manual for this package failed to build, some documents may be unavailable. Please inspect thebuild logs for more information.

Citation

Development and contributors

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