as.data.frame.tbl_validation: Retrieve validation results as a data.frame

In data-cleaning/validatedb: Validate Data in a Database using 'validate'

Retrieve validation results as a data.frame

Description

Retrieve validation results as a data.frame

Usage

## S3 method for class 'tbl_validation'
as.data.frame(x, row.names = NULL, optional = FALSE, ...)

Arguments

x	tbl_validation(), result of a confront() of tbl with a rule set.
row.names	ignored
optional	ignored
...	ignored

Value

data.frame, result of the query on the database.

Examples

# create a table in a database
income <- data.frame(id = letters[1:2], age=c(12,35), salary = c(1000,NA))
con <- dbplyr::src_memdb()
tbl_income <- dplyr::copy_to(con, income, overwrite=TRUE)

# Let's define a rule set and confront the table with it:
rules <- validator( is_adult   = age >= 18
                  , has_income = salary > 0
                  , mean_age   = mean(age,na.rm=TRUE) > 20
                  )
# and confront!
cf <- confront(tbl_income, rules, key = "id")
as.data.frame(cf)

# and now with a sparse result:
cf <- confront(tbl_income, rules, key = "id", sparse=TRUE)
as.data.frame(cf)

data-cleaning/validatedb documentation built on June 11, 2022, 4:33 p.m.