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@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
______________________________________________
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.
