Re: [R] About reshape dataset

2016-10-23 Thread P Tennant
You could convert your data from a wide format to a long format using the reshape function in base R: DF2 <- reshape(DF, direction="long", idvar=names(DF)[1:3], varying=c("site1_elev", "site1_temp", "site2_elev", "site2_temp"), v.names=c("elev", "temp"), times=1:2

Re: [R] About reshape dataset

2016-10-22 Thread Daniel Nordlund
On 10/22/2016 10:52 AM, lily li wrote: The code I'm using is: require(reshape) DF2 = melt(DF, id.vars = c('year', 'month', 'day'), measure.vars = c('site1_elev', 'site2_elev', 'site1_temp', 'site2_temp')) But it didn't work. On Sat, Oct 22, 2016 at 11:50 AM, lily li wrote: Hi R users, I wan

Re: [R] About reshape dataset

2016-10-22 Thread lily li
The code I'm using is: require(reshape) DF2 = melt(DF, id.vars = c('year', 'month', 'day'), measure.vars = c('site1_elev', 'site2_elev', 'site1_temp', 'site2_temp')) But it didn't work. On Sat, Oct 22, 2016 at 11:50 AM, lily li wrote: > Hi R users, > > I want to melt a dataframe, but it mixed u

[R] About reshape dataset

2016-10-22 Thread lily li
Hi R users, I want to melt a dataframe, but it mixed up the variables. DF is the original dataset: year month day site1_elev site2_elev site1_temp site2_temp 2000 561300 150020 21 2000 571300 1500