Package: dbc 0.0.0.9000

Patrick Barks

dbc: Dictionary-Based Cleaning

Tools for dictionary-based data cleaning.

Authors:Patrick Barks [aut, cre]

# Install 'dbc' in R:

install.packages('dbc', repos = c('https://epicentre-msf.r-universe.dev', 'https://cloud.r-project.org'))

Datasets:

clean_categ1 - A cleaning dictionary for categorical variables in example dataset 'll1'
clean_dates1 - A cleaning dictionary for categorical variables in example dataset 'll1'
clean_num1 - A cleaning dictionary for numeric variables in example dataset 'll1'
dict_categ1 - A dictionary of allowed values for categorical variables in example dataset 'll1'
ll1 - An example messy dataset to clean
ll2 - An example messy dataset to clean, an extension of 'll1'

On CRAN:

Last updated from:756c98eb86. Checks:9 OK. Indexed: yes.

Target	Result	Time
linux-devel-x86_64	OK	129
source / vignettes	OK	190
linux-release-x86_64	OK	130
macos-release-arm64	OK	94
macos-oldrel-arm64	OK	85
windows-devel	OK	101
windows-release	OK	124
windows-oldrel	OK	79
wasm-release	OK	99

Help page	Topics
Produce a dictionary of non-valid categorical values within a dataset, for use in subsequent data cleaning	check_categorical
Produce a dictionary of non-valid date values within a dataset, for use in subsequent data cleaning	check_dates
Produce a dictionary of non-valid numeric values within a dataset, for use in subsequent data cleaning	check_numeric
A cleaning dictionary for categorical variables in example dataset 'll1'	clean_categ1
Clean categorical variables within a dataset based on a dictionary of value-replacement pairs	clean_categorical
Clean date variables within a dataset based on a dictionary of value-replacement pairs	clean_dates
A cleaning dictionary for categorical variables in example dataset 'll1'	clean_dates1
A cleaning dictionary for numeric variables in example dataset 'll1'	clean_num1
Clean numeric variables within a dataset based on a dictionary of value-replacement pairs	clean_numeric
A dictionary of allowed values for categorical variables in example dataset 'll1'	dict_categ1
An example messy dataset to clean	ll1
An example messy dataset to clean, an extension of 'll1'	ll2
Parse dates	parse_dates
Standardize text prior to matching to account for minor variation in character case, spacing, punctuation, or use of accents	std_text