dunnns dunnns - 1 year ago 81
R Question

Reshaping issues in R: my reshaped dataframe changes 3 variables into 1

I'm a relative newbie to R and trying to reshape my data into long format from wide format and having problems. I'm thinking that my problem may be due to having made the data.frame from a data.frame that I have created in R, getting mean values of the large data.frame into another data.frame.

What I have done is this created an empty data.frame (ndf):

ndf <- data.frame(matrix(ncol = 0, nrow = 3))

Then used lapply to get the means from the large data.frame (ldf) into separate columns in the new data.frame, with the year being used from the large data.frame:

ndf$Year <- names(ldf)
ndf$col1 <- lapply(ldf, function(i) {mean(i$col1)})
ndf$col2 <- lapply(ldf, function(i) {mean(i$col2)})

The melted function in reshape2 does not work apparently because there are non-atomic 'measure' columns.

For using the reshape base function I have used the code:

reshape.ndf <- reshape(ndf,
varying = list(names(ndf)[2:7]),
v.names = "cover",
timevar = "species",
times = names(ndf[2:7]),
new.row.names = 1:1000,
direction = "long")

My output is then essentially just using the first row for the variables. So my wide data.frame looks like this (sorry for the strange names):

Year Cladonia.portentosa Erica.tetralix Eriophorum.vaginatum
1 2014 11.75 35 55
2 2015 15.75 25.75 70
3 2016 22.75 5 37.5

And the long data.frame looks like this:

Year species cover id
1 2014 Cladonia.portentosa 11.75 1
2 2015 Cladonia.portentosa 11.75 2
3 2016 Cladonia.portentosa 11.75 3
4 2014 Erica.tetralix 35.00 1
5 2015 Erica.tetralix 35.00 2
6 2016 Erica.tetralix 35.00 3

Where the "cover" column should have the value from each year put into the cell with the corresponding year.

Please could someone tell me where I've gone wrong!?

Answer Source

here is an example of 'melting' in tidyr. you'll need tidyr but I also like dplyr and am including it here to encourage its use along with the rest of the tidyverse. you'll find endless great tutorials on the web...


lets use iris as an example, i want a long form where species, variable and value are the collumns.


here it is with gather(). we specify that variable and value are the collumn names for the new 'melted' collumns. we also specify that we do not want to melt the collumn Species which we want to remain its own collumn.

iris_long <- iris %>%
  gather(variable, value, -Species)

inspect the iris_long object to make sure it worked.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download