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]]
Try this: xtabs(Val ~ Var1 + Var2, data = x) On Wed, Mar 31, 2010 at 3:23 PM, Kim Jung Hwa <kimhwamaillist at 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 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. >-- Henrique Dallazuanna Curitiba-Paran?-Brasil 25? 25' 40" S 49? 16' 22" O
Hi Kim, look at the reshape() command with direction="wide". Or at the reshape package. HTH, Stephan Kim Jung Hwa schrieb:> 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 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. >