Hi,
May be:
z<-data.frame(x,y,stringsAsFactors=FALSE)
simplify2array(split(z[,-1],z$x))
# a b
#[1,] 1.0 1.01
#[2,] 1.2 1.03
#[3,] 1.1 1.00
as.data.frame(simplify2array(split(z[,-1],z$x)))
A.K.
----- Original Message -----
From: Brijesh Gulati <brij...@gmail.com>
To: r-help@r-project.org
Cc:
Sent: Sunday, August 4, 2013 8:49 AM
Subject: [R] question: data.frame data conversion
Hello, I have a data.frame with repeating rows and corresponding value. For
instance, "z" will be an example of that.
x = c("a","a", "a", "b","b","b")
y = c(1.0, 1.2, 1.1, 1.01, 1.03, 1.0)
z = as.data.frame(cbind(x,y))
> z
x y
1 a 1
2 a 1.2
3 a 1.1
4 b 1.01
5 b 1.03
6 b 1
So, you see that "a" and "b" are repeated 3 times and have three different
value. I would like to convert this data into something like the following.
a b
1.0 1.01
1.2 1.03
1.1 1.00
In the above, repeating rows (a,b) become columns and their values show up
in their respective column.
Finally, to clarify few things. The number of rows of each repeating item
(a or b) would be the same and hence, the number of row expected in the
output shall be the same.
[[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.
______________________________________________
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.
