r - How to reshape data from long to wide format? -
i'm having trouble rearranging following data frame:
set.seed(45) dat1 <- data.frame( name = rep(c("firstname", "secondname"), each=4), numbers = rep(1:4, 2), value = rnorm(8) ) dat1 name numbers value 1 firstname 1 0.3407997 2 firstname 2 -0.7033403 3 firstname 3 -0.3795377 4 firstname 4 -0.7460474 5 secondname 1 -0.8981073 6 secondname 2 -0.3347941 7 secondname 3 -0.5013782 8 secondname 4 -0.1745357
i want reshape each unique "name" variable rowname, "values" observations along row , "numbers" colnames. sort of this:
name 1 2 3 4 1 firstname 0.3407997 -0.7033403 -0.3795377 -0.7460474 5 secondname -0.8981073 -0.3347941 -0.5013782 -0.1745357
i've looked @ melt
, cast
, few other things, none seem job.
using reshape
function:
reshape(dat1, idvar = "name", timevar = "numbers", direction = "wide")
Comments
Post a Comment