Learn R Programming

dcmodifydb (version 0.3.1)

Modifying Rules on a DataBase

Description

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'.

Copy Link

Version

Install

install.packages('dcmodifydb')

Monthly Downloads

30

Version

0.3.1

License

MIT + file LICENSE

Issues

Pull Requests

Stars

Forks

Maintainer

Edwin Jonge

Last Published

June 17th, 2022

Functions in dcmodifydb (0.3.1)

modify,ANY,modifier-method

Apply corrections/derivations to a db table
dcmodifydb-package

dcmodifydb: Modifying Rules on a DataBase
modifier_to_sql

Utility function to extract SQL statements
is_working_db

Rule check on the database
dump_sql

Show generated sql
get_table_con

Get table connection
person

Person data, income and smoking habits