[R] Wide to long form conversion

Gang Chen gangchen6 at gmail.com
Thu Oct 6 22:28:52 CEST 2011


I have some data 'myData' in wide form (attached at the end), and
would like to convert it to long form. I wish to have five variables
in the result:

1) Subj: factor
2) Group: between-subjects factor (2 levels: s / w)
3) Reference: within-subject factor (2 levels: Me / She)
4) F: within-subject factor (2 levels: F1 / F2)
5) J: within-subject factor (2 levels: J1 / J2)

As this is the first time I'm learning such a conversion, could
someone help me out?

Many thanks,
Gang

> myData

   Group MeF1 MeJ1 SheF1 SheJ1 MeF2 MeJ2 SheF2 SheJ2 Subj
1      s    4    5     6    10    3    6     6     9   S1
2      s    6    5     5     6    4    3     5     6   S2
3      s    7    4     6     5    7    4     5     3   S3
4      s    8    5     8     7    7    1     8     6   S4
5      s   10    6     4     7    9    6     4     6   S5
6      s    5    2     4     7    4    1     4     2   S6
7      s   13    2    10     4   11    2     4     3   S7
8      s    8    1     3    11    6    0     3    10   S8
9      s    6    9     5     8    6    8     5     6   S9
10     s   14    5     6    10   13    5     5    10  S10
11     s   15    2    18     2   14    1    18     2  S11
12     s    6    9     4     9    5   11     3     8  S12
13     s    5    5     0    12    4    3     0     8  S13
14     s    5    6     4     9    4    6     2     6  S14
15     s   14    5    12     3   12    3    11     3  S15
16     s    7    2    11     3    5    2    10     2  S16
17     s    1    7     4     5    1    6     3     5  S17
18     s    6    2     7     4    6    2     7     4  S18
19     s    9    4     8     5   10    4     6     3  S19
20     s    8    2     6     5    9    2     6     4  S20
21     s    6    5     5     7    6    6     5     5  S21
22     s    8    8     3     7    6    7     5     3  S22
23     s   11    4     6     7    1    1     6     4  S23
24     s    6    3     2     4    6    4     2     2  S24
25     s    4    4     6     6    2    3     4     6  S25
26     w    5    9     4     7    3    7     3     5  S26
27     w    7    6     3     5    4    1     0     4  S27
28     w   10    4    14     2    8    4    10     2  S28
29     w    9    7     5     6    8    4     5     3  S29
30     w    9    2     7     5    6    2     6     5  S30
31     w    6    7     6     7    6    5     5     8  S31
32     w    7    6    12     7    6    3    10     7  S32
33     w   12    3     8     9   11    3     4     7  S33
34     w   12    2    10     5    9    2     6     3  S34
35     w    6    3    10     4    5    3     5     3  S35
36     w    9    3     9     9    6    3     7     8  S36
37     w    5   11     7     7    4   11     3     4  S37
38     w    7    4     4     6    7    3     1     5  S38
39     w    6    5     1     8    3    3     0     8  S39
40     w   10    3    10     2    7    3     7     2  S40
41     w    1   11     7     5    1    8     4     3  S41
42     w   10    5     6    10   10    4     3     9  S42
43     w    6    3     9     2    4    2     6     0  S43
44     w    9    5    11     4    5    4     7     3  S44
45     w    8    5     6     3    8    4     2     3  S45
46     w    8    4     8     7    4    1     2     6  S46
47     w   12    2     6     2   10    1     5     2  S47
48     w   10    6     9     8    7    5     7     8  S48
49     w   13    6    15     1   12    4    14     0  S49
50     w    7    8     1    12    4    7     1    11  S50
51     w   12    3     9     4    9    1     7     4  S51



More information about the R-help mailing list