[R] Could anyone help me reshape this "wide" data into "longitudinal" one? Thanks

Frank Duan fhduan at gmail.com
Mon Nov 29 00:13:20 CET 2004


Dear R people,

I have a matrix like this:

      var1   var2    var3    var4 
a1   7.1   7.2       8.1    8.2 
a2  10.5  10.6    ...       ...
a3
b1
b2
b3
b4
c1
c2
...

The matrix row names are "a1", "a2", ......  and the matrix column
names are "var1", "var2", "var3" and "var4". Now I want to reshape
this data into a longitudinal-formatted one like this:


subject    seq   time    resp        
a              1      1        7.1
a              1      2        7.2
a              1      3        8.1
a              1      4        8.2
a              2      1       10.5 
a              2      2       10.6
a              2      3         ...
a              2      4         ...
a              3      1         ...
a              3      2
a              3      3
a              3      4
b              1      1
b              1      2
b              1      3
b              1      4
b              2      1
b              2      2
b              2      3
b              2      4
...             ...    ...
...             ...    ...
...             ...    ...


I always met errors when using "reshape" function. Could anyone give
me an idea how to do it?

Many thanks to you,

Frank




More information about the R-help mailing list