Means multiple columns by multiple groups [duplicate]

by

We can use dplyr with summarise_at to get mean of the concerned columns after grouping by the column of interest

library(dplyr)
airquality %>%
   group_by(City, year) %>% 
   summarise_at(vars("PM25", "Ozone", "CO2"), mean)

Or using the devel version of dplyr (version – ‘0.8.99.9000’)

airquality %>%
     group_by(City, year) %>%
     summarise(across(PM25:CO2, mean))

More Related Contents:

  1. Spread with duplicate identifiers (using tidyverse and %>%) [duplicate]
  2. Use dynamic name for new column/variable in `dplyr`
  3. data.table vs dplyr: can one do something well the other can’t or does poorly?
  4. Extract a dplyr tbl column as a vector
  5. Pass arguments to dplyr functions
  6. dplyr::select function clashes with MASS::select
  7. Sum across multiple columns with dplyr
  8. dplyr: nonstandard column names (white space, punctuation, starts with numbers)
  9. dplyr filter: Get rows with minimum of variable, but only the first if multiple minima
  10. dplyr mutate/replace several columns on a subset of rows
  11. dplyr: How to use group_by inside a function?
  12. Concatenate row-wise across specific columns of dataframe
  13. Count non-NA values by group [duplicate]
  14. dplyr mutate with conditional values
  15. Get last row of each group in R [duplicate]
  16. ignore NA in dplyr row sum
  17. dplyr on data.table, am I really using data.table?
  18. Set certain values to NA with dplyr
  19. dplyr::group_by_ with character string input of several variable names
  20. Use filter in dplyr conditional on an if statement in R
  21. combine two data frames with all posible combinations
  22. dplyr / R cumulative sum with reset
  23. finding close match from data frame 1 in data fame 2
  24. Get first and last values per group – dplyr group_by with last() and first()
  25. Add a column with count of NAs and Mean
  26. How does one stop using rowwise in dplyr?
  27. select columns based on multiple strings with dplyr contains()
  28. dplyr – groupby on multiple columns using variable names
  29. Error with select function from dplyr
  30. Collapse all columns by an ID column [duplicate]

Leave a Comment