Take a look here.

http://stackoverflow.com/questions/2185252/reshaping-data-frame-from-wide-to-long-format

Andrew Miles
Department of Sociology
Duke University

On Oct 6, 2011, at 4:28 PM, Gang Chen wrote:

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


	[[alternative HTML version deleted]]

