get_all_missing: Get insight onto where missing values will enter when joining...

Description Usage Arguments Examples

Description

Enter data frames and a joining key and generate a table that shows you the variable, number of NA values in the data frames, and number of NA values introduced when full joining the data frames. Additionally, see this output in two different bar plots called 'Coded Missing Values Within Datasets' and 'Missing Values In Datasets Resulting From Joins'. This function enables you to specify as many data frames as you wish. You specify the keys, where each data frame must have at least one of the keys in it. The function gives insight into missing values and if they come from your current data or result from the join.

Usage

1
get_all_missing(..., df_names = NULL, keys)

Arguments

...

enter as many data frames as you would like

df_names

the data frame names

keys

the primary key in your data frames

Examples

1
2
3
4
get_all_missing(demographics, math, ell, keys = c("student_id", "year"))
get_all_missing(list(demographics, math, ell),
     df_names = c("demographics", "math", "ell"),
     keys = c("student_id", "year"))

stenhaug/combineR documentation built on May 31, 2019, 5:13 p.m.