How to sum values from same names?

Question

R program

I need to sum values from same names which are repeated in a list.

I have a list like,

  Person  Money
1  1        3
2  2        1
3  1        2
4  3        1
5  2        1

I need,

  Person  Money
1  1    (3+2=)5
2  2        2
3  3        1

`aggregate(Money ~ Person, data=df, sum)` – thelatemail Apr 08 '13 at 21:10 — thelatemail, Apr 08 '13 at 21:10

score 2 · Answer 1 · answered Apr 08 '13 at 21:26

2

Here is a solution with ddply from plyr

library(plyr)
z=data.frame(ddply(YourDataFrame,.(Person),summarise))

answered Apr 08 '13 at 21:26

Duck

score 1 · Answer 2 · answered Apr 09 '13 at 01:59

1

Here is a solution using the base function tapply.

df = data.frame(Person=c("Joe","Joe","Fred","Jane","Fred","Jane"), Money=c(2,5,2,1,7,2))
tapply(df$Money, df$Person, FUN=sum)

answered Apr 09 '13 at 01:59

Jeffrey Evans

2 Answers2