Wide to long form conversion
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.