Can someone help me with the proper usage of the
reshape function?
Let's say I have a dataset with columns like this
(wide format):
Id Sex Group Test Day1 Day 2 Day 3...
And I want to transpose this into something like this
(thin):
Id Sex Group Test Time
Where the new column labeled time contains all the
time variables (Day 1, Day 2, Day 3...) that were in
the wide format. I just cannot get it to work right
using the reshape function. I'm sure there is
something that I'm missing. I just can't get a handle
on how to use this reshape function.
Thanks so much in advance for any help.
Dave
__________________________________________________
HotJobs - Search new jobs daily now
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Reshape function
3 messages · DAVID JENSEN, Jun Yan, Thomas Lumley
Suppose the wide dataframe is dat.w, and variable ID is a unique
id for each row. Something like the following may work:
dat.l <- reshape(dat.w, idvar="ID", varying=list(c("Day1", "Day2",
"Day3")), v.names="Response", timevar="Day", direction="long")
Notice here, I assumed Day1, Day2, and Day3 are variable Response at
different days. So I named the new variable "Response", and the new time
variable "Day".
Jun
On Fri, 1 Nov 2002, DAVID JENSEN wrote:
Can someone help me with the proper usage of the
reshape function?
Let's say I have a dataset with columns like this
(wide format):
Id Sex Group Test Day1 Day 2 Day 3...
And I want to transpose this into something like this
(thin):
Id Sex Group Test Time
Where the new column labeled time contains all the
time variables (Day 1, Day 2, Day 3...) that were in
the wide format. I just cannot get it to work right
using the reshape function. I'm sure there is
something that I'm missing. I just can't get a handle
on how to use this reshape function.
Thanks so much in advance for any help.
Dave
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
There seem to be a lot of questions about using reshape(), indicating perhaps that the documentation isn't clear enough. Improvements would be welcome. -thomas -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._