[R] reshaping data.frame question

From: Matthias Braeunig <mb.atelier_at_web.de>
Date: Mon 26 Jun 2006 - 22:23:18 EST


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Dear R-helpers,

my data.frame is of the form

x <- data.frame( f=gl(4,3), X=rep(0:2,4), p=c(.1,.2,.3)) x

   f X p

1  1 0 0.1
2  1 1 0.2
3  1 2 0.3
4  2 0 0.1
5  2 1 0.2
6  2 2 0.3
7  3 0 0.1
8  3 1 0.2
9  3 2 0.3
10 4 0 0.1
11 4 1 0.2
12 4 2 0.3

which tabulates some values p(X) for several factors f.

Now I want to put it in "wide" format, so that factor levels appear as column heads. Note also that X starts from zero. It would be nice if I could simply access p_f[X==0] as f[0]. How can I possibly do that?

(The resilting object does not have to be a data.frame. As there are only numeric values, also a matrix would do.)

I tried the following

y<-unstack(x,form=p~f)
row.names(y) <- 0:2
y

   X1 X2 X3 X4

0 0.1 0.1 0.1 0.1
1 0.2 0.2 0.2 0.2
2 0.3 0.3 0.3 0.3

Now, how to access X3[0], say?

Maybe reshape would be the right tool, but I could not figure it out.

I appreciate your help. Thanks!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)

iD8DBQFEn9G2XjamRUP82DkRAorGAJ9JirG7WtNJLWRQkJvgW0zTFHTYagCgvONw IC4jgoxE2+CsOmmogv5dzF0=
=24Kj
-----END PGP SIGNATURE-----



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Mon Jun 26 22:35:22 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Tue 27 Jun 2006 - 04:12:30 EST.

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