Prev 201530 / 398506 Next

reshape question

Hadley Wickham · 2009-11-25T03:05:19Z

> I don't really understand what you want and the example solution throws away > quite a lot of data, so consider this alternative: > > data.out2 rater.3 n.3 ? rater.4 n.4 > 11 ? 11 0.1183333 ?79 ? ? ? ?NA ?NA ? ? ? ?NA ?NA ? ? ? ?NA ?NA > 114 114 0.2478709 113 ? ? ? ?NA ?NA ? ? ? ?NA ?NA ? ? ? ?NA ?NA > 12 ? 12 0.3130655 ?54 0.3668242 ?54 ? ? ? ?NA ?NA ? ? ? ?NA ?NA > 121 121 0.2400000 331 ? ? ? ?NA ?NA ? ? ? ?NA ?NA ? ? ? ?NA ?NA >

Hadley Wickham

Tue, Nov 24, 2009 7:05 PM

Or

library(reshape)
df <- melt(data.out2, na.rm = T, id = "id")
df <- cbind(df, colsplit(df$variable, "\\.", c("var", "time")))

cast(df, id + time ~ var)

See http://had.co.nz/reshape for more details.

Hadley

http://had.co.nz/

Thread (5 messages)

AC Del Re reshape question Nov 24 David Winsemius reshape question Nov 24 Hadley Wickham reshape question Nov 24 Joe King reshape question Nov 24 AC Del Re reshape question Nov 24