Message-ID: <CAHmzXO74mzO1XsSset0EL1TiB4Ri2wYM04oiA8nwHoZKRhyRGg@mail.gmail.com>
Date: 2011-10-06T21:04:19Z
From: Gang Chen
Subject: Wide to long form conversion
In-Reply-To: <EDFE37E4-8F06-4149-AFD6-45A2E1370006@gmail.com>
Thanks for the pointer! I still couldn't figure out how to convert my
data because the example at stackoverflow seems to have only one
variable (Year) while there are three within-subject variables plus
one between-subjects variable. Any further help?
Gang
On Thu, Oct 6, 2011 at 4:34 PM, Andrew Miles <rstuff.miles at gmail.com> wrote:
> 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 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.
>
>