Nice thing about R is there is more than one way of doing something: > x name ip Bsent Breceived 1 a 1 0.00 0.00 2 a 2 1.43 19.83 3 a 1 0.00 0.00 4 a 2 1.00 1.00 5 b 1 0.00 2.00 6 b 3 0.00 2.00 7 b 2 2.00 0.00 8 b 2 2.00 0.00 9 b 1 24.40 22.72 10 c 1 1.00 1.00 11 c 1 2.00 1.00 12 c 1 2.00 1.00 13 c 1 90.97 15.70 14 d 0 0.00 0.00 15 d 1 30.00 17.14 > require(sqldf) > sqldf('select name, sum(ip) as ip, sum(Bsent) as Bsent, + sum(Breceived) as Breceived + from x + group by name') name ip Bsent Breceived 1 a 6 2.43 20.83 2 b 9 28.40 26.72 3 c 4 95.97 18.70 4 d 1 30.00 17.14 >
On Sun, Nov 7, 2010 at 8:59 AM, Mohan L <l.mohanphys...@gmail.com> wrote: > Dear All, > > I have a data frame like this: > > name ip Bsent Breceived > a 1 0.00 0.00 > a 2 1.43 19.83 > a 1 0.00 0.00 > a 2 1.00 1.00 > b 1 0.00 2.00 > b 3 0.00 2.00 > b 2 2.00 0.00 > b 2 2.00 0.00 > b 1 24.40 22.72 > c 1 1.00 1.00 > c 1 2.00 1.00 > c 1 2.00 1.00 > c 1 90.97 15.70 > d 0 0.00 0.00 > d 1 30.00 17.14 > > I want to sum up the similar name into one row, like : > > name ip Bsent Breceived > a 6 2.43 20.83 > b 9 28.40 26.72 > c > d > > I need help to sum up. Thanks for your time. > > > Thanks & Rg > Mohan L > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > -- Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem that you are trying to solve? ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.