Try: as.data.frame(with(x, tapply(Val, list(Var1, Var2), sum)))
On Wed, Mar 31, 2010 at 3:37 PM, Kim Jung Hwa <kimhwamaill...@gmail.com> wrote: > Thanks Henrique and Stephan for your reply! > > Henrique, I'm planning to do some arthitmetic operations on tranformed > (matrix) data and then would like to convert it back to original format (as > a data frame)... is there an equivalent easy command for this too? Thanks, > > On Wed, Mar 31, 2010 at 2:26 PM, Henrique Dallazuanna <www...@gmail.com> > wrote: >> >> Try this: >> >> xtabs(Val ~ Var1 + Var2, data = x) >> >> On Wed, Mar 31, 2010 at 3:23 PM, Kim Jung Hwa <kimhwamaill...@gmail.com> >> wrote: >> > Hi All, >> > >> > Can someone help me reshape following data: >> > >> > Var1 Var2 Val >> > A X 1 >> > A Y 2 >> > A Z 3 >> > B X 4 >> > B Y 5 >> > B Z 6 >> > >> > to some kind of matrix/tabular format (preferably as a matrix), may be >> > like >> > >> > Var1 X Y Z >> > A 1 2 3 >> > B 4 5 6 >> > >> > Any help would be greatly appreciated, >> > Kim >> > >> > [[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. >> > >> >> >> >> -- >> Henrique Dallazuanna >> Curitiba-Paraná-Brasil >> 25° 25' 40" S 49° 16' 22" O > > -- Henrique Dallazuanna Curitiba-Paraná-Brasil 25° 25' 40" S 49° 16' 22" O ______________________________________________ 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.
