tidyr (version 0.3.1)

complete: Complete a data frame with missing combinations of data.

Description

This is a wrapper around expand(), left_join() and replace_na that's useful for completing missing combinations of data. It turns implicitly missing values into explicitly missing values.

Usage

complete(data, ..., fill = list())

Arguments

data

A data frame

...

Specification of columns to expand.

To find all unique combinations of x, y and z, including those not found in the data, supply each variable as a separate argument. To find only the combinations that occur in the data, supply them as a single a

fill

A named list that for each variable supplies a single value to use instead of NA for missing combinations.

Examples

library(dplyr)
df <- data_frame(
  group = c(1:2, 1),
  item_id = c(1:2, 2),
  item_name = c("a", "b", "b"),
  value1 = 1:3,
  value2 = 4:6
)
df %>% complete(group, c(item_id, item_name))

# You can also choose to fill in missing values
df %>% complete(group, c(item_id, item_name), fill = list(value1 = 0))

Run the code above in your browser using DataCamp Workspace