[R] help to sum up data frame

[John Kane]

With your data set as the data.frame xx

library(reshape2)
xx <- melt(xx)
dcast(xx, name ~ variable, sum)



--- On Sun, 11/7/10, Mohan L <l.mohanphysics at gmail.com> wrote:

> From: Mohan L <l.mohanphysics at gmail.com>
> Subject: [R] help to sum up data frame
> To: r-help at r-project.org
> Received: Sunday, November 7, 2010, 8:59 AM
> 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 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.
>