hi all, my data is here, -------------------------------------------------------------------------------------------------- data clss number 1 A 1 2 B 2 3 C 3 4 A 4 5 B 5 6 C 6 7 A 7 8 B 8 9 C 9 ----------------------------------------------------------------------------------------------------- I want to this format clss number A 12 B 15 C 18 is there a way to solve this problem? -- View this message in context: http://r.789695.n4.nabble.com/To-summary-data-tp4629887.html Sent from the R help mailing list archive at Nabble.com.
On 14-05-2012, at 07:14, mrzung wrote:> hi all, > > my data is here, > -------------------------------------------------------------------------------------------------- > data > > clss number > 1 A 1 > 2 B 2 > 3 C 3 > 4 A 4 > 5 B 5 > 6 C 6 > 7 A 7 > 8 B 8 > 9 C 9 > ----------------------------------------------------------------------------------------------------- > I want to this format > > clss number > A 12 > B 15 > C 18 > > is there a way to solve this problem??aggregate mydata <- data.frame(clss=rep(c("A","B","C"),rep=3),number=1:9, stringsAsFactors=FALSE) aggregate(number ~ .,data=mydata,sum) Berend
One way is to use the reshape2 package ==============================library(reshape2) dcast(xx, A ~ . , sum) =============================== John Kane Kingston ON Canada> -----Original Message----- > From: mrzung46 at gmail.com > Sent: Sun, 13 May 2012 22:14:02 -0700 (PDT) > To: r-help at r-project.org > Subject: [R] To summary data > > hi all, > > my data is here, > -------------------------------------------------------------------------------------------------- > data > > clss number > 1 A 1 > 2 B 2 > 3 C 3 > 4 A 4 > 5 B 5 > 6 C 6 > 7 A 7 > 8 B 8 > 9 C 9 > ----------------------------------------------------------------------------------------------------- > I want to this format > > clss number > A 12 > B 15 > C 18 > > is there a way to solve this problem? > > -- > View this message in context: > http://r.789695.n4.nabble.com/To-summary-data-tp4629887.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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.____________________________________________________________ FREE ONLINE PHOTOSHARING - Share your photos online with your friends and family! Visit http://www.inbox.com/photosharing to find out more!