reshape() should do it: > d V1 V2 V3 V4 V5 1 A1 B1 C1 D1 E1 2 A2 B2 C2 D2 E2 3 A3 B3 C3 D3 E3 > d2 <- reshape(d, varying=list(names(d)[1:4]), direction="long")[c(3,1)] > d2[order(d2$V5),] V1 V5 1.1 A1 E1 1.2 B1 E1 1.3 C1 E1 1.4 D1 E1 2.1 A2 E2 2.2 B2 E2 2.3 C2 E2 2.4 D2 E2 3.1 A3 E3 3.2 B3 E3 3.3 C3 E3 3.4 D3 E3
Andy > From: jose silva > > Dear all: > > I have this: > > A1 B1 C1 D1 E1 > A2 B2 C2 D2 E2 > A3 B3 C3 D3 E3 > > And I want this > > A1 E1 > B1 E1 > C1 E1 > D1 E1 > A2 E2 > B2 E2 > C2 E2 > D2 E2 > A3 E3 > B3 E3 > C3 E3 > D3 E3 > > Example: > > m<- matrix(1:15,nrow=3,byrow=T) > m > v<- unlist(list(t(m[,1:4]))) > u<- rep(c(5,10,15),c(4,4,4)) > data.frame(v,u) > > This is the result I want but I would like to learn a simpler > way to do it. > Any clue? On the other hand, how can I reorganize the data in > the way it was in the begining? I hope someone can help me on this... > Thanks in advance > > j. silva > [[alternative HTML version deleted]] > > ______________________________________________ > 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 > [[alternative HTML version deleted]] > > ______________________________________________ > 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 > > > ______________________________________________ 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