Proper idiom for adding zero count rows in tidyr/dplyr

by

Since dplyr 0.8 you can do it by setting the parameter .drop = FALSE in group_by:

X.tidy <- X.raw %>% group_by(x, y, .drop = FALSE) %>% summarise(count=sum(z))
X.tidy
# # A tibble: 4 x 3
# # Groups:   x [2]
#   x     y     count
#   <fct> <fct> <int>
# 1 A     i         1
# 2 A     ii        5
# 3 B     i        15
# 4 B     ii        0

This will keep groups made of all the levels of factor columns so if you have character columns you might want to convert them (thanks to Pate for the note).

More Related Contents:

  1. Gather multiple sets of columns
  2. Combine Multiple Columns Into Tidy Data [duplicate]
  3. R spreading multiple columns with tidyr [duplicate]
  4. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  5. Using spread with duplicate identifiers for rows
  6. Add NAs to make all list elements equal length
  7. Reshape from long to wide and create columns with binary value
  8. adding default values to item x group pairs that don’t have a value (df %>% spread %>% gather seems strange)
  9. combine two data frames with all posible combinations
  10. Spread with duplicate identifiers (using tidyverse and %>%) [duplicate]
  11. Spreading a two column data frame with tidyr
  12. How to replace all NA in a dataframe using tidyr::replace_na? [duplicate]
  13. tidyverse – prefered way to turn a named vector into a data.frame/tibble
  14. Unlisting columns by groups
  15. How does one access the piped data.frame in dplyr::funs?
  16. Reshaping multiple sets of measurement columns (wide format) into single columns (long format)
  17. Filter multiple values on a string column in dplyr
  18. Reshape multiple values at once
  19. Concatenate strings by group with dplyr [duplicate]
  20. Can dplyr package be used for conditional mutating?
  21. Dplyr join on by=(a = b), where a and b are variables containing strings?
  22. Can I replace NAs when joining two data frames with dplyr?
  23. dplyr broadcasting single value per group in mutate
  24. How to deal with nonstandard column names (white space, punctuation, starts with numbers)
  25. dplyr if_else() vs base R ifelse()
  26. Using column names as function arguments
  27. How to change the now deprecated dplyr::funs() which includes an ifelse argument?
  28. pivot_longer with multiple classes causes error (“No common type”)
  29. Mutate multiple variable to create multiple new variables
  30. Add row in each group using dplyr and add_row()

Leave a Comment