Dear R-list, Is there a way to convert the typical long R data-format to a 1-line per subject format?
I have data formatted as: Group subj condition variable 1 1 1 746.36625 2 2 1 1076.152857 1 3 1 1076.152857 2 4 1 657.4263636 1 5 1 854.1266667 2 6 1 1191.676154 1 7 1 1028.175385 1 1 2 46.36625 2 2 2 76.152857 1 3 2 76.152857 2 4 2 57.4263636 1 5 2 54.1266667 2 6 2 191.676154 1 7 2 028.175385 ... Here, one line equals the value of one subjects VARIABLE in function of the GROUP and the CONDITION. However, I would like to rearrange the data so that the columns of my data equal the 2 conditions and the lines the subjects. This is something like: subj group condition1 condition2 1 1 746.36625 46.36625 2 2 1076.152857 76.152857 ... I know its possible the other way around. But that's not what I need (this time). Before anyone asks: Yes, I want to do some analysis on my data in SPSS, so I need the rearranged format. Regards and Thanks, Dieter ------------------------------------------ Dieter Vanderelst dieter _ vanderelst AT emailengine DOT org d DOT vanderelst AT tue DOT nl Eindhoven University of Technology Faculty of Industrial Design Designed Intelligence Group Den Dolech 2 5612 AZ Eindhoven The Netherlands Tel +31 40 247 91 11 ______________________________________________ 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.
