Group by multiple columns in dplyr, using string vector input

by

Just so as to write the code in full, here’s an update on Hadley’s answer with the new syntax:

library(dplyr)

df <-  data.frame(
    asihckhdoydk = sample(LETTERS[1:3], 100, replace=TRUE),
    a30mvxigxkgh = sample(LETTERS[1:3], 100, replace=TRUE),
    value = rnorm(100)
)

# Columns you want to group by
grp_cols <- names(df)[-3]

# Convert character vector to list of symbols
dots <- lapply(grp_cols, as.symbol)

# Perform frequency counts
df %>%
    group_by_(.dots=dots) %>%
    summarise(n = n())

output:

Source: local data frame [9 x 3]
Groups: asihckhdoydk

  asihckhdoydk a30mvxigxkgh  n
1            A            A 10
2            A            B 10
3            A            C 13
4            B            A 14
5            B            B 10
6            B            C 12
7            C            A  9
8            C            B 12
9            C            C 10

More Related Contents:

  1. Use dynamic name for new column/variable in `dplyr`
  2. Why does summarize or mutate not work with group_by when I load `plyr` after `dplyr`?
  3. Calculate group mean, sum, or other summary stats. and assign column to original data
  4. What does %>% function mean in R?
  5. Use variable names in functions of dplyr
  6. How to convert a factor to integer\numeric without loss of information?
  7. The difference between bracket [ ] and double bracket [[ ]] for accessing the elements of a list or dataframe
  8. Numbering rows within groups in a data frame
  9. How can I view the source code for a function?
  10. Calculate the mean by group
  11. Remove rows with all or some NAs (missing values) in data.frame
  12. Side-by-side plots with ggplot2
  13. Pass a string as variable name in dplyr::filter
  14. Sum across multiple columns with dplyr
  15. dplyr mutate/replace several columns on a subset of rows
  16. Confusion between factor levels and factor labels
  17. How to sort a character vector where elements contain letters and numbers?
  18. General suggestions for debugging in R
  19. ignore NA in dplyr row sum
  20. Multiline Comment Workarounds?
  21. How to select last N observation from each group in dplyr dataframe?
  22. mutate function is not updating
  23. Switch displayed traces via plotly dropdown menu
  24. Rename multiple columns given character vectors of column names and replacement [duplicate]
  25. Re-ordering factor levels in data frame [duplicate]
  26. Error: could not find function “%>%”
  27. dplyr change many data types
  28. How to perform multiple left joins using dplyr in R [duplicate]
  29. Create a group index for values connected directly and indirectly
  30. dplyr replacing na values in a column based on multiple conditions

Leave a Comment