How sum a column corresponding to group elements?

Asked Jul 04 '19 at 15:13

Active Jul 04 '19 at 15:59

Viewed 20 times

I have a group and in each group there are some individuals. How I can add the value of a column for each person? here is an example:

  Group   Person   colum
    1        1       25
    1        1        5 
    1        1       10
    1        2        4
    1        2        8
    2        1        5
    2        1        5
    2        2        20

So I want a new column say TOT like this:

  Group   Person    TOT
    1        1       40
    1        1       40 
    1        1       40
    1        2       12
    1        2       12
    2        1       10
    2        1       10
    2        2       20

edited Jul 04 '19 at 15:59

hannes101

2,410
1
17
40

asked Jul 04 '19 at 15:13

sherek_66

1

Just do `with(df1, ave(colum, group, Person, FUN = sum))` – akrun Jul 04 '19 at 15:18
`within` will be better – yarnabrina Jul 04 '19 at 15:22
1

@akrun Well, I assumed OP's going to use the following `within(df1, TOT<- ...))`. Doesn't matter much. – yarnabrina Jul 04 '19 at 15:31

How sum a column corresponding to group elements?

0 Answers0