Aggregate data in R

by

Assuming your data frame is named “x”:

aggregate(x$B, list(cut(x$A, breaks=c(0, 200, 400))), mean)
#     Group.1     x
# 1   (0,200]  90.0
# 2 (200,400] 107.5

With “data.table”, you can do the following:

library(data.table)
as.data.table(x)[, .(RANGE = mean(B)), by = .(MEAN = cut(A, c(0, 200, 400)))]
#         MEAN RANGE
# 1:   (0,200]  90.0
# 2: (200,400] 107.5

More Related Contents:

  1. How to sum a variable by group
  2. Aggregate / summarize multiple variables per group (e.g. sum, mean)
  3. Collapse / concatenate / aggregate a column to a single comma separated string within each group
  4. Mean per group in a data.frame [duplicate]
  5. Count number of rows within each group
  6. Faster ways to calculate frequencies and cast from long to wide
  7. Count number of rows per group and add result to original data frame
  8. Apply several summary functions on several variables by group in one call
  9. Summarizing multiple columns with dplyr? [duplicate]
  10. Extract the maximum value within each group in a dataframe [duplicate]
  11. Group by multiple columns and sum other multiple columns
  12. Select the first and last row by group in a data frame
  13. Select the top N values by group
  14. Apply function conditionally
  15. Summarizing by subgroup percentage in R
  16. Collapsing rows where some are all NA, others are disjoint with some NAs
  17. Aggregate a data frame based on unordered pairs of columns
  18. Compute mean and standard deviation by group for multiple variables in a data.frame
  19. Aggregate and reshape from long to wide
  20. Returning first row of group
  21. Get the means of sub groups of means in R
  22. Apply several summary functions (sum, mean, etc.) on several variables by group in one call
  23. aggregate() puts multiple output columns in a matrix instead
  24. R sum a variable by two groups [duplicate]
  25. data.frame Group By column [duplicate]
  26. R use ddply or aggregate
  27. Combining duplicated rows in R and adding new column containing IDs of duplicates
  28. Run a custom function on a data frame in R, by group
  29. Aggregate by week in R
  30. How can I count the number of NAs per group?

Leave a Comment