Group by multiple columns and sum other multiple columns

by

The data.table way is :

DT[, lapply(.SD,sum), by=list(col1,col2,col3,...)]

or

DT[, lapply(.SD,sum), by=colnames(DT)[1:10]]

where .SD is the (S)ubset of (D)ata excluding group columns. (Aside: If you need to refer to group columns generically, they are in .BY.)

More Related Contents:

  1. Aggregate / summarize multiple variables per group (e.g. sum, mean)
  2. Faster ways to calculate frequencies and cast from long to wide
  3. Extract row corresponding to minimum value of a variable by group
  4. How to create a lag variable within each group?
  5. Fastest way to add rows for missing time steps?
  6. Aggregate a dataframe on a given column and display another column
  7. Aggregate a data frame based on unordered pairs of columns
  8. Why is plyr so slow?
  9. Returning first row of group
  10. Get the means of sub groups of means in R
  11. R use ddply or aggregate
  12. Why does data.table update names(DT) by reference, even if I assign to another variable?
  13. How to get week numbers from dates?
  14. Which data.table syntax for left join (one column) to prefer
  15. Evaluating both column name and the target value within `j` expression within `data.table`
  16. Fill in missing values by group in data.table
  17. dplyr on data.table, am I really using data.table?
  18. data.table and parallel computing
  19. how to show a legend on dual y-axis ggplot
  20. Why is as.Date slow on a character vector?
  21. aggregate() puts multiple output columns in a matrix instead
  22. data.frame Group By column [duplicate]
  23. How to group data.table by multiple columns?
  24. Apply a function to a subset of data.table columns, by column-indices instead of name
  25. Selecting a subset of columns in a data.table
  26. Merge overlapping ranges into unique groups, in dataframe
  27. add missing rows to a data table
  28. Trouble converting long list of data.frames (~1 million) to single data.frame using do.call and ldply
  29. assigning by reference into loaded package datasets
  30. calculating sum of previous 3 rows in R data.table (by grid-square)

Leave a Comment