Reshape by multiple variables
On Tue, 26 Nov 2002, Laura Gross wrote:
Dear list
I'm using the reshape command and want to reshape a wide data set to a
long one
e.g. I have the variables y1,y2,y3,age1,age2,age3,sex,ethnic
I want my new long data set to consist of the variables y (which has
been created from y1,y2,y3), age (which has been created from
age1,age2,age3), sex and ethnic
I have tried to use the command:
data1<-reshape(data,varying=list(c("y1","y2","y3"),c("age1","age2","age"
)),v.names="y","age", times=1:3,direction="long")
but it tells me I am trying to duplicate row names?
How can I put multiple time-varying variables into the varying bit?
The command you gave has two clear errors: you forgot the 3 on age3 and you didn't use c() around the v.names argument. Even so, I don't get an error message from it (just the wrong result). With these corrected it works for me:
data
y1 y2 y3 age1 age2 age3 sex ethnic 1 1 11 101 5 25 35 male 1 2 2 12 102 6 26 36 male 2 3 3 13 103 7 27 37 male 3 4 4 14 104 8 28 38 female 4 5 5 15 105 9 29 39 female 5
reshape(data,varying=list(c("y1","y2","y3"),c("age1","age2","age3")),v.names=c
("y","age"),times=1:3,direction="long")
sex ethnic time y age id
1.1 male 1 1 1 5 1
2.1 male 2 1 2 6 2
3.1 male 3 1 3 7 3
4.1 female 4 1 4 8 4
5.1 female 5 1 5 9 5
1.2 male 1 2 11 25 1
2.2 male 2 2 12 26 2
3.2 male 3 2 13 27 3
4.2 female 4 2 14 28 4
5.2 female 5 2 15 29 5
1.3 male 1 3 101 35 1
2.3 male 2 3 102 36 2
3.3 male 3 3 103 37 3
4.3 female 4 3 104 38 4
5.3 female 5 3 105 39 5
-thomas
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._