Sum of data in a column based on categorical condition from another column

Asked Sep 22 '19 at 05:14

Active Sep 22 '19 at 05:20

Viewed 18 times

I have a dataframe df below

 df
 Col A   COl B   
  A       25
  A       25
  B       50
  B       50

I need below

 df1
 ColA    COL B   Sum
  A       25      50 
  A       25      50
  B       50      100
  B       50      100

Is there a way?

asked Sep 22 '19 at 05:14

Dev P

Yeah I know the summary function :) but it creates a new dataset. But I need the sum in this dataset only – Dev P Sep 22 '19 at 05:17
`df$Sum <- ave(df$ColB, df$ColA, FUN = sum)` – Ronak Shah Sep 22 '19 at 05:18
In `dplyr` use `mutate` instead of `summarize` – A. Suliman Sep 22 '19 at 05:20

0 Answers0