complete_se | R Documentation |
Complete a data frame with missing combinations of data. Turns implicit missing values into explicit missing values.
complete_se(data, col_terms, fill = list(), env = parent.frame())
data |
A data frame or tbl. |
col_terms |
A character vector of column names or expressions to complete by. |
fill |
A list that for each variable supplies a single value to use instead of NA for missing combinations. |
env |
The environment as an argument (in case the function is called from another function). |
This is a standard evaluation interface for tidyr::complete()
. The purpose of the function is to be able to use a vector of characters (column names) as the argument for expanding the data frame.
The data frame with implicit missing values identified.
# data frame used to illustrate tidyr::complete() df <- wrapr::build_frame( "group" , "item_id", "item_name", "value1", "value2" | 1 , 1 , "a" , 1L , 4L | 2 , 2 , "b" , 2L , 5L | 1 , 2 , "b" , 3L , 6L ) # columns to complete by col_terms <- qc(group, item_id, item_name) df %.>% complete_se(., col_terms) df %.>% complete_se(., col_terms, fill = list(value1 = 0)) # with nesting col_terms <- c("group", "tidyr::nesting(item_id, item_name)") df %.>% complete_se(., col_terms) df %.>% complete_se(., col_terms, fill = list(value1 = 0)) df %.>% complete_se(., col_terms, fill = list(value1 = 0, value2 = 0))
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.