Get the means of sub groups of means in R

by

With base, using aggregate 

> aggregate(WLN~GROUP+WORD, mean, data=df)
  GROUP WORD      WLN
1     1    1 3.333333
2     1    2 2.333333
3     2    3 1.333333
4     2    4 1.000000

where df is @Metrics’ data.

Another alternative is using summaryBy from doBy package

> library(doBy)
> summaryBy(WLN~GROUP+WORD, FUN=mean, data=df)
  GROUP WORD WLN.mean
1     1    1 3.333333
2     1    2 2.333333
3     2    3 1.333333
4     2    4 1.000000

More Related Contents:

  1. Faster ways to calculate frequencies and cast from long to wide
  2. Group by multiple columns and sum other multiple columns
  3. Aggregate a dataframe on a given column and display another column
  4. Aggregate a data frame based on unordered pairs of columns
  5. Returning first row of group
  6. R use ddply or aggregate
  7. How to sum a variable by group
  8. Reshape three column data frame to matrix (“long” to “wide” format) [duplicate]
  9. Count number of rows per group and add result to original data frame
  10. Why does summarize or mutate not work with group_by when I load `plyr` after `dplyr`?
  11. Apply several summary functions on several variables by group in one call
  12. Summarizing multiple columns with dplyr? [duplicate]
  13. Extract the maximum value within each group in a dataframe [duplicate]
  14. How to create a lag variable within each group?
  15. Why are my dplyr group_by & summarize not working properly? (name-collision with plyr)
  16. Unique rows, considering two columns, in R, without order
  17. calculate the mean for each column of a matrix in R
  18. Summarizing by subgroup percentage in R
  19. Collapsing rows where some are all NA, others are disjoint with some NAs
  20. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  21. Generate random numbers with fixed mean and sd
  22. Change value of variable with dplyr
  23. calculating mean for every n values from a vector
  24. Aggregate and reshape from long to wide
  25. Split Data Frame into Rows of Fixed Size
  26. R sum a variable by two groups [duplicate]
  27. Combining duplicated rows in R and adding new column containing IDs of duplicates
  28. Aggregate by week in R
  29. Can `ddply` (or similar) do a sliding window?
  30. How can I count the number of NAs per group?

Leave a Comment