Add a new column of the sum by group [duplicate]

by

I agree with @mnel at least on his first point. I didn’t see ave demonstrated in the answers he cited and I think it’s the “simplest” base-R method. Using that data.frame(cbind( ...)) construction should be outlawed and teachers who demonstrate it should be stripped of their credentials.

set.seed(123)
 df<-data.frame(y=sample( c("A","B","C"), 10, T), 
                X=sample(c (1,2,3), 10, T))
  df<-df[order(df$y),]  # that step is not necessary for success.
df

 df$sum <- ave(df$X, df$y, FUN=sum)
 df
   y X sum
1  A 3   6
6  A 3   6
3  B 3   8
7  B 1   8
9  B 1   8
10 B 3   8
2  C 2   6
4  C 2   6
5  C 1   6
8  C 1   6

More Related Contents:

  1. Matrix operation in R: I have a square matrix whose determinant is zero, i need to find its inverse in R programing. Is it possible ,if yes how? [closed]
  2. Selecting rows in R with “Yes” in one column of a set of columns, and NOT “Yes” in all columns of another set of columns
  3. Add count of unique / distinct values by group to the original data
  4. How to convert Excel date format to proper date in R
  5. What is the difference between `%in%` and `==`?
  6. Better explanation of when to use Imports/Depends
  7. session not created: This version of ChromeDriver only supports Chrome version 74 error with ChromeDriver Chrome using Selenium
  8. Fitting several regression models with dplyr
  9. How to subtract months from a date in R?
  10. How to unload a package without restarting R
  11. regular expressions in base R: ‘perl=TRUE’ vs. the default (PCRE vs. TRE)
  12. Sort columns of a dataframe by column name
  13. How can I remove empty factors from ggplot2 facets?
  14. How to add a ggplot2 subtitle with different size and colour?
  15. Efficiently sum across multiple columns in R
  16. Remove duplicates keeping entry with largest absolute value
  17. Plot data in descending order as appears in data frame [duplicate]
  18. How to call a function using the character string of the function name in R?
  19. How can I fix corrupted dates in R?
  20. R knitr: Possible to programmatically modify chunk labels?
  21. How can I add a table to my ggplot2 output?
  22. Switch displayed traces via plotly dropdown menu
  23. Rename multiple columns given character vectors of column names and replacement [duplicate]
  24. Uniroot solution in R
  25. R: Reshaping Multiple Columns from Long to Wide
  26. Re-ordering factor levels in data frame [duplicate]
  27. How to create a dendrogram with colored branches?
  28. edit strip size ggplot2
  29. Select row with most recent date by group
  30. ggplot: colour points by groups based on user defined colours

Leave a Comment