Complete dataframe with missing combinations of values

by

You can use the tidyr::complete function:

complete(df, distance, years = full_seq(years, period = 1), fill = list(area = 0))

# A tibble: 14 x 3
   distance years  area
   <fct>    <dbl> <dbl>
 1 100         1.   40.
 2 100         2.    0.
 3 100         3.    0.
 4 100         4.    0.
 5 100         5.   50.
 6 100         6.   60.
 7 100         7.    0.
 8 NPR         1.    0.
 9 NPR         2.    0.
10 NPR         3.   10.
11 NPR         4.   20.
12 NPR         5.    0.
13 NPR         6.    0.
14 NPR         7.   30.

or slightly shorter:

complete(df, distance, years = 1:7, fill = list(area = 0))

More Related Contents:

  1. Reshaping multiple sets of measurement columns (wide format) into single columns (long format)
  2. Gather multiple sets of columns
  3. How to use Pivot_longer to reshape from wide-type data to long-type data with multiple variables
  4. pivot_wider issue “Values in `values_from` are not uniquely identified; output will contain list-cols”
  5. Combine Multiple Columns Into Tidy Data [duplicate]
  6. R spreading multiple columns with tidyr [duplicate]
  7. Reshape multiple values at once
  8. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  9. Proper idiom for adding zero count rows in tidyr/dplyr
  10. How to spread columns with duplicate identifiers?
  11. Is it possible to use spread on multiple columns in tidyr similar to dcast? [duplicate]
  12. Add NAs to make all list elements equal length
  13. Reshape from long to wide and create columns with binary value
  14. adding default values to item x group pairs that don’t have a value (df %>% spread %>% gather seems strange)
  15. How to use tidyr::separate when the number of needed variables is unknown [duplicate]
  16. How to complete missing factor levels in data frame?
  17. combine two data frames with all posible combinations
  18. Tidyr how to spread into count of occurrence [duplicate]
  19. R: Reshaping Multiple Columns from Long to Wide
  20. tidyverse pivot_longer several sets of columns, but avoid intermediate mutate_wider steps [duplicate]
  21. Spread with duplicate identifiers (using tidyverse and %>%) [duplicate]
  22. data.table equivalent of tidyr::complete()
  23. Changing Million/Billion abbreviations into actual numbers? ie. 5.12M -> 5,120,000 [duplicate]
  24. Spreading a two column data frame with tidyr
  25. pivot_longer with multiple classes causes error (“No common type”)
  26. How to replace all NA in a dataframe using tidyr::replace_na? [duplicate]
  27. How to transpose a dataframe in tidyverse?
  28. tidyverse – prefered way to turn a named vector into a data.frame/tibble
  29. pivot_longer into multiple columns
  30. Unlisting columns by groups

Leave a Comment