Aggregate / summarize multiple variables per group (e.g. sum, mean)

by

Yes, in your formula, you can cbind the numeric variables to be aggregated:

aggregate(cbind(x1, x2) ~ year + month, data = df1, sum, na.rm = TRUE)
   year month         x1          x2
1  2000     1   7.862002   -7.469298
2  2001     1 276.758209  474.384252
3  2000     2  13.122369 -128.122613
...
23 2000    12  63.436507  449.794454
24 2001    12 999.472226  922.726589

See ?aggregate, the formula argument and the examples.

More Related Contents:

  1. How to sum a variable by group
  2. Count number of rows within each group
  3. Reshaping data.frame from wide to long format
  4. How do I make a list of data frames?
  5. Collapse / concatenate / aggregate a column to a single comma separated string within each group
  6. Sort (order) data frame rows by multiple columns
  7. Replacing NAs with latest non-NA value
  8. Split data frame string column into multiple columns
  9. Filter data.frame rows by a logical condition
  10. Quickly reading very large tables as dataframes
  11. Split data.frame based on levels of a factor into new data.frames
  12. Combine a list of data frames into one data frame by row
  13. Combine two data frames by rows (rbind) when they have different sets of columns
  14. Count number of rows per group and add result to original data frame
  15. Counting unique / distinct values by group in a data frame
  16. Pass a data.frame column name to a function
  17. Apply several summary functions on several variables by group in one call
  18. How to split a data frame?
  19. How to plot all the columns of a data frame in R
  20. Select the first and last row by group in a data frame
  21. How does one reorder columns in a data frame?
  22. Assign multiple columns using := in data.table, by group
  23. Convert data.frame column format from character to factor
  24. How to replace NA values in a table for selected columns
  25. Combine two or more columns in a dataframe into a new column with a new name
  26. Dollar sign before a variable
  27. Cleaning `Inf` values from an R dataframe
  28. DT[!(x == .)] and DT[x != .] treat NA in x inconsistently
  29. Merge overlapping ranges into unique groups, in dataframe
  30. Convert a data frame to a data.table without copy

Leave a Comment