Skip to content

Reshape function

3 messages · DAVID JENSEN, Jun Yan, Thomas Lumley

#
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
#
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:

            
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._