check_subset() tests if the values of the chosen column c1 of data frame t1 are a subset of the values
of column c2 of data frame t2.
check_subset(t1, c1, t2, c2)
| t1 | The data frame that contains column |
|---|---|
| c1 | The column of |
| t2 | The data frame that contains column |
| c2 | The column of the second data frame that has to contain all values of |
Returns t1, invisibly, if the check is passed.
Otherwise an error is thrown and the reason for it is explained.
data_1 <- tibble::tibble(a = c(1, 2, 1), b = c(1, 4, 1), c = c(5, 6, 7)) data_2 <- tibble::tibble(a = c(1, 2, 3), b = c(4, 5, 6), c = c(7, 8, 9)) # this is passing: check_subset(data_1, a, data_2, a) # this is failing: try(check_subset(data_2, a, data_1, a))#> # A tibble: 1 x 3 #> a b c #> <dbl> <dbl> <dbl> #> 1 3 6 9 #> Error : Column `a` of table `data_2` contains values (see examples above) that are not present in column `a` of table `data_1`.