[R] how to reshape the data.frame from long to wide in a specific order

From: zhenjiang xu <zhenjiang.xu_at_gmail.com>
Date: Mon, 14 Mar 2011 21:06:06 -0400


Hi,

For example, the data.frame like:

origdata.long <- read.table(header=T, con <- textConnection('  subject sex condition measurement

       1   M   control         7.9
       1   M     first        12.3
       1   M    second        10.7
       2   F   control         6.3
       2   F     first        10.6
       2   F    second        11.1
       3   F   control         9.5
       3   F     first        13.1
       3   F    second        13.8
       4   M   control        11.5
       4   M     first        13.4
       4   M    second        12.9

 '))
close(con)

Given a vector c('first', 'second', 'control), how can I reshape the data.frame to this?

# subject sex  first second   control

# 1 M 12.3 10.7 7.9
# 2 F 10.6 11.1 6.3
# 3 F 13.1 13.8 9.5
# 4 M 13.4 12.9 11.5
I know reshape() can transform the data.frame from long to wide, but it seems not able to control the order of the columns.

Thanks ahead of time

-- 
Best,
Zhenjiang

	[[alternative HTML version deleted]]

______________________________________________
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.
Received on Tue 15 Mar 2011 - 01:09:17 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 15 Mar 2011 - 03:50:21 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive