inspectr (version 1.0.0)

three_col_check: Check a column for data fidelity using criteria related to two additional columns.

Description

Check a column for data fidelity using criteria related to two additional columns.

Usage

three_col_check(colname1, colname2, colname3, data = data, fun, output = FALSE, stage = NULL, ...)

Arguments

colname1

character string specifying the name of the column within your dataframe that will be the subject of the checks.

colname2

character string specifying the name of a second column to be used in the check criteria.

colname3

character string specifying the name of a third column to be used in the check criteria.

data

the dataframe containing the data.

fun

the check function you'd like to apply to the data.

output

logical. If FALSE, the function returns a dataframe containing only records that failed the specified check. If TRUE, invisibly prints an excel output file containing only the records that failed the specified check.

stage

An optional character string that can be used to specify the stage of the checking process in which the check is occurring. Only useful if output = TRUE. If a value is specified, a that value is prefixed to the output file; if no value is given, no stage prefix is attached.

...

arguments to be passed through to the function specified in fun

Value

col_check(output = FALSE) returns a dataframe containing only records that failed the specified check.col_check(output = TRUE) invisibly prints an excel output file containing only records that failed the specified check.

Examples

three_col_check(colname1 = "Perf_Lvl", colname2 = "Var1", colname3 = "Var2",
data = dataset, fun = function(col1, col2, col3){
   col1 %in% c("Basic", "Intermediate", "Advanced") |
   (is.na(col1) & (col3 %% 2 ==0) & (col2 %% 2 ==1 ))
   })