dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output

by

The issue is still open, but in the meantime, especially since your data are already factored, you can use complete from “tidyr” to get what you might be looking for:

library(tidyr)
df %>%
  group_by(b) %>%
  summarise(count_a=length(a)) %>%
  complete(b)
# Source: local data frame [3 x 2]
# 
#        b count_a
#   (fctr)   (int)
# 1      1       6
# 2      2       6
# 3      3      NA

If you wanted the replacement value to be zero, you need to specify that with fill:

df %>%
  group_by(b) %>%
  summarise(count_a=length(a)) %>%
  complete(b, fill = list(count_a = 0))
# Source: local data frame [3 x 2]
# 
#        b count_a
#   (fctr)   (dbl)
# 1      1       6
# 2      2       6
# 3      3       0

More Related Contents:

  1. Why does summarize or mutate not work with group_by when I load `plyr` after `dplyr`?
  2. How to select the rows with maximum values in each group with dplyr? [duplicate]
  3. Gather multiple sets of columns
  4. How to create a lag variable within each group?
  5. Why are my dplyr group_by & summarize not working properly? (name-collision with plyr)
  6. Combine Multiple Columns Into Tidy Data [duplicate]
  7. Unique rows, considering two columns, in R, without order
  8. R spreading multiple columns with tidyr [duplicate]
  9. Applying a function to every row of a table using dplyr?
  10. dplyr: “Error in n(): function should not be called directly”
  11. Using spread with duplicate identifiers for rows
  12. Count number of rows by group using dplyr
  13. How to strsplit different number of strings in certain column by do function
  14. Proper idiom for adding zero count rows in tidyr/dplyr
  15. Change value of variable with dplyr
  16. Add NAs to make all list elements equal length
  17. Reshape from long to wide and create columns with binary value
  18. adding default values to item x group pairs that don’t have a value (df %>% spread %>% gather seems strange)
  19. combine two data frames with all posible combinations
  20. Spread with duplicate identifiers (using tidyverse and %>%) [duplicate]
  21. Spreading a two column data frame with tidyr
  22. How to replace all NA in a dataframe using tidyr::replace_na? [duplicate]
  23. tidyverse – prefered way to turn a named vector into a data.frame/tibble
  24. Unlisting columns by groups
  25. Is there a dplyr equivalent to data.table::rleid?
  26. Replace NA with previous or next value, by group, using dplyr
  27. How to aggregate a dataframe by week?
  28. R dplyr rowwise mean or min and other methods?
  29. Dealing with spaces and “weird” characters in column names with dplyr::rename()
  30. Filtering rows in R unexpectedly removes NAs when using subset or dplyr::filter

Leave a Comment