[R] Equivalent of Excel pivot tables in R

From: ppaarrkk <simon_ecc_at_yahoo.co.uk>
Date: Fri, 25 Apr 2008 14:54:26 -0700 (PDT)

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_at_r-project.org mailing list
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Received on Fri 25 Apr 2008 - 23:18:53 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Sat 26 Apr 2008 - 08:30:31 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive