[R] stack data (from rows to column)

arun smartpink111 at yahoo.com
Mon Nov 25 03:47:23 CET 2013



HI,
Try:
 library(reshape2)
 melt(data,measure.vars=c("t1","t2"),var="ind")

A.K.


On Sunday, November 24, 2013 9:31 PM, Kristi Glover <kristi.glover at hotmail.com> wrote:
I was just wondering how to stack values of columns to rows. Would you give me some idea how I can stack? I just want to stack columns 2 and 3 but not column1. The column 1 is supposed to be repeated. I was able to stack using "stack" but I could not repeat the column 1.  

For example I have data like this
group t1 t2 t3
101 -31.77083 -33.79167
103 -27.26667 -27.9

data<-structure(list(group = c(101L, 103L), t1 = c(-31.77083, -27.26667
), t2 = c(-33.79167, -27.9)), .Names = c("group", "t1", "t2"), class = "data.frame", row.names = c(NA, 
-2L))

-----
Want to make like this"
group     values     ind
101     -31.7708     t1
103     -27.2667     t1
101     -33.7917     t2
103     -27.9     t2

final<-structure(list(group = c(101L, 103L, 101L, 103L), values = c(-31.77083, 
-27.26667, -33.79167, -27.9), ind = structure(c(1L, 1L, 2L, 2L
), .Label = c("t1", "t2"), class = "factor")), .Names = c("group", 
"values", "ind"), class = "data.frame", row.names = c(NA, -4L
))

I really appreciate for your help.
thanks 
            
                          
    [[alternative HTML version deleted]]

______________________________________________
R-help at 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.




More information about the R-help mailing list