Joining aggregated values back to the original data frame [duplicate]

by

One line of code does the trick:

new <- ddply( df, "group1", transform, numcolwise(mean))
new

group1 group2      values    meanValue
1       1      A  0.48742905 -0.121033381
2       1      A -0.04493361 -0.121033381
3       1      C -0.62124058 -0.121033381
4       1      C -0.30538839 -0.121033381
5       2      A  1.51178117  0.004803931
6       2      B  0.73832471  0.004803931
7       2      A -0.01619026  0.004803931
8       2      B -2.21469989  0.004803931
9       3      B  1.12493092  0.758597929
10      3      C  0.38984324  0.758597929
11      3      B  0.57578135  0.758597929
12      3      A  0.94383621  0.758597929

identical(df, new)
[1] TRUE

More Related Contents:

  1. summarizing multiple variables in group by
  2. Faster ways to calculate frequencies and cast from long to wide
  3. Reshape three column data frame to matrix (“long” to “wide” format) [duplicate]
  4. Why does summarize or mutate not work with group_by when I load `plyr` after `dplyr`?
  5. How to select the rows with maximum values in each group with dplyr? [duplicate]
  6. Convert data from long format to wide format with multiple measure columns
  7. Group by multiple columns and sum other multiple columns
  8. How to create a lag variable within each group?
  9. Why are my dplyr group_by & summarize not working properly? (name-collision with plyr)
  10. Fastest way to add rows for missing time steps?
  11. Unique rows, considering two columns, in R, without order
  12. Applying a function to every row of a table using dplyr?
  13. Idiomatic R code for partitioning a vector by an index and performing an operation on that partition
  14. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  15. dplyr: “Error in n(): function should not be called directly”
  16. Aggregate a dataframe on a given column and display another column
  17. Aggregate a data frame based on unordered pairs of columns
  18. Is there a R function that applies a function to each pair of columns?
  19. Create columns from factors and count [duplicate]
  20. Why is plyr so slow?
  21. Object not found error with ddply inside a function
  22. How to get top n companies from a data frame in decreasing order
  23. Returning first row of group
  24. Split Data Frame into Rows of Fixed Size
  25. R: Split unbalanced list in data.frame column
  26. Get the means of sub groups of means in R
  27. Standard error bars using stat_summary
  28. Replace missing values (NA) in one data set with values from another where columns match
  29. Sum of rows based on column value
  30. Can `ddply` (or similar) do a sliding window?

Leave a Comment