Hi Janet,
This might help:
jcdf<-read.table(text="scen trans evap flow
1 1.1 0.1 0.09
1 1.2 0.2 0.10
1 1.3 0.3 0.20
2 2.1 0.1 0.09
2 2.2 0.2 0.10
2 2.3 0.3 0.20
3 3.1 0.1 0.09
3 3.2 0.2 0.10
3 3.3 0.3 0.20",
header=TRUE)
library(prettyR)
stretch_df(jcdf,"scen",c("trans","evap","flow"))[,2:10]
Jim
On Sat, Jun 29, 2019 at 1:42 AM Janet Choate <jsc....@gmail.com> wrote:
>
> Hello R community,
> I have a data frame that has multiple observations in a single column that
> I would like to break into multiple columns.
> The data looks something like this:
>
> scen trans evap flow
> 1 1.1 0.1 0.09
> 1 1.2 0.2 0.10
> 1 1.3 0.3 0.20
> 2 2.1 0.1 0.09
> 2 2.2 0.2 0.10
> 2 2.3 0.3 0.20
> 3 3.1 0.1 0.09
> 3 3.2 0.2 0.10
> 3 3.3 0.3 0.20
>
> the column scen runs from 1 through 500, and each scen # contains 1461 rows
> - i.e. there are 1461 observations for scen1, 1461 observations for scen2,
> etc...
> i want to split the trans, evap, and flow columns out by scen #, so that i
> end up with something like:
>
> trans1 trans2 trans3
> 1.1 2.1 1.1
> 1.2 2.2 3.2
> 1.3 2.3 3.3
>
> and same for the other variables.
> thought i could use the separate command to do this, but either not the
> right approach or i am not executing it properly.
> thank you for any assistance,
> Janet
> --
> Tague Team Lab Manager
> 1005 Bren Hall
> UCSB, Santa Barbara, CA.
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
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.
