[R] reshaping data.frame question
Matthias Braeunig
mb.atelier at web.de
Mon Jun 26 14:23:18 CEST 2006
-----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-----
More information about the R-help
mailing list