[R] Equivalent of Excel pivot tables in R

ppaarrkk simon_ecc at yahoo.co.uk
Fri Apr 25 23:54:26 CEST 2008

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.

More information about the R-help mailing list