[R] help to sum up data frame

[David Winsemius]

On Nov 7, 2010, at 8:59 AM, Mohan L 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

?aggregate

 > dfrm <- rd.txt("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")


 > aggregate(dfrm[ , -1], list(dfrm[,1]), sum)
   Group.1 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

-- David
>
> I need help to sum up. Thanks for your time.
>
>
> Thanks & Rg
> Mohan L
>
> ______________________________________________
> R-help at 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.

David Winsemius, MD
West Hartford, CT