Hi, I forgot the first part (I'm sorry):
table(var1,var2) var2 var1 x y z a 1 0 2 b 0 1 2 HTH, Jorge On Fri, Apr 25, 2008 at 7:25 PM, Jorge Ivan Velez <[EMAIL PROTECTED]> wrote: > > Hi, > > Try this: > > x="var1 var2 var3 > a x 10 > b y 20 > a z 10 > b z 20 > a z 10 > b z 20" > > yourdata=read.table(textConnection(x),header=TRUE) > attach(yourdata) > > res=tapply(var3,yourdata[,-3],sum) # With tapply! > res[is.na(res)]<-0 > res > var2 > var1 x y z > a 10 0 20 > b 0 20 40 > > See also ?tapply. > > > HTH, > > Jorge > > > > On Fri, Apr 25, 2008 at 5:54 PM, ppaarrkk <[EMAIL PROTECTED]> wrote: > >> >> Can somebody tell me how to do the equivalent of a pivot table in R ? >> >> >> For example, if I have : >> >> var1 var2 var3 >> a x 10 >> b y 20 >> a z 10 >> b z 20 >> a z 10 >> b z 20 >> >> I could have : >> >> x y z >> a 1 0 2 >> b 0 1 2 >> >> where entries in the table are counts of var3. >> >> x y z >> a 10 0 20 >> b 0 20 40 >> >> where entries are sums of var3. >> >> >> >> I would expect it to be tapply(), but I can't see how it would be done. >> >> >> Any suggestions please. >> >> >> -- >> View this message in context: >> http://www.nabble.com/Equivalent-of-Excel-pivot-tables-in-R-tp16906289p16906289.html >> Sent from the R help mailing list archive at Nabble.com. >> >> ______________________________________________ >> 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. >> > > > [[alternative HTML version deleted]] ______________________________________________ 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.
