R: Is there an efficient way to perform groupBy on one column and sum another column?

Question

I am attempting to work with two columns using R.

I want to be able to groupBy column 1, but total the value 2.

col1 col2
A    3
B    2
A    5
B    1
B    4

Example result should be:

A    8
B    7

I have looked at "aggregate", "summaryBy", and "by" both, but I am missing something because I am not getting the desired output.

Any help would be appreciated...

score 2 · Answer 1 · edited May 23 '17 at 12:20

2

Consider your data is called dat then use aggregate, it worked for me

> aggregate(.~col1, FUN="sum", data=dat )
  col1 col2
1    A    8
2    B    7

For further examples see this post

edited May 23 '17 at 12:20

Community

answered Apr 01 '14 at 04:03

Jilber Urbina

Billy34 · Accepted Answer · 2014-04-01T07:55:23.143

1

Package data.table is your friend!

library(data.table)
dt <- data.table(your_dataframe,key="col1")
dt[,list(col2=sum(col2)),by="col1" ]

edited Apr 01 '14 at 07:55

answered Apr 01 '14 at 07:41

Billy34

2 Answers2