Hi:
This is straightforward with the reshape package:
library(reshape)
origdata.long$condition <- factor(origdata.long$condition,
levels = c('first', 'second', 'control'))
cast(origdata.long, subject + sex ~ condition)
Using measurement as value column. Use the value argument to cast to
override this choice
subject sex first second control
1 1 M 12.3 10.7 7.9
2 2 F 10.6 11.1 6.3
3 3 F 13.1 13.8 9.5
4 4 M 13.4 12.9 11.5
HTH,
Dennis
On Mon, Mar 14, 2011 at 6:06 PM, zhenjiang xu <zhenjiang...@gmail.com>wrote:
> 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@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]]
______________________________________________
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.
