wclapham
2010-Mar-29 19:15 UTC
[R] Reshaping a data frame with a series of factors and 23 repeated measures
I have a data frame that I created using read.table on a csv spreadsheet. The data look like the following: Steer.ID stocker.trt Finish.trt Date Days Wt ...... Steer.Id, stocker.trt, Finish.trt are factors------ Date, Days, Wt are data that are repeated 23 times (wide format). I want to reshape the data such that I have the correct Steer.ID, stocker.trt, Finish.trt identifying all of the repeated measures data in a long format. I am a newbie at R and need to develop the skill in reshaping data, so that I can handle routine problems like described above. Thanks so much in advance for help or advice. Bill -- View this message in context: http://n4.nabble.com/Reshaping-a-data-frame-with-a-series-of-factors-and-23-repeated-measures-tp1695500p1695500.html Sent from the R help mailing list archive at Nabble.com.
Ista Zahn
2010-Mar-29 19:35 UTC
[R] Reshaping a data frame with a series of factors and 23 repeated measures
Hi Bill, Without an example dataset it's hard to see exactly what you need to do. But you can get started by looking at the documentation for the reshape function (?reshape), and by looking at the reshape package. The reshape package has an associated web page (http://had.co.nz/reshape/) with links to papers and other information to help you get started. Best, Ista On Mon, Mar 29, 2010 at 3:15 PM, wclapham <william.clapham at ars.usda.gov> wrote:> > I have a data frame that I created using read.table on a csv spreadsheet. > The data look like the following: > > Steer.ID ? stocker.trt ? Finish.trt ?Date ? Days Wt ...... > > Steer.Id, stocker.trt, Finish.trt are factors------ Date, Days, Wt are data > that are repeated 23 times (wide format). > > I want to reshape the data such that I have the correct Steer.ID, > stocker.trt, Finish.trt identifying all of the repeated measures data in a > long ?format. > > I am a newbie at R and need to develop the skill in reshaping data, so that > I can handle routine problems like described above. > > Thanks so much in advance for help or advice. > > Bill > -- > View this message in context: http://n4.nabble.com/Reshaping-a-data-frame-with-a-series-of-factors-and-23-repeated-measures-tp1695500p1695500.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >-- Ista Zahn Graduate student University of Rochester Department of Clinical and Social Psychology http://yourpsyche.org
wclapham
2010-Mar-30 13:34 UTC
[R] Reshaping a data frame with a series of factors and 23 repeated measures
Ista, I have looked at the reshape package and have used melt¹ successfully on simpler tables. I tried it here, but have not been successful. I think I just need to gain experience. I am loving R and am having a difficult time with data structure issues. I am attaching the data set that I am trying to manipulate. Ultimately, I would like to be able to analyze these data with ANOVA and repeated measures, and also be able to plot growth, wt * days. I appreciate any help or guidance on references to read that will help me solve my problems. The data set represents wt over time (starting with days=0, birth day) for steers. Factors include Stockering and Finishing treatments. Regards, Bill On 3/29/10 3:39 PM, "Ista Zahn [via R]" <ml-node+1695531-1043721504-210803@n4.nabble.com> wrote:> Hi Bill, > Without an example dataset it''s hard to see exactly what you need to > do. But you can get started by looking at the documentation for the > reshape function (?reshape), and by looking at the reshape package. > The reshape package has an associated web page > (http://had.co.nz/reshape/) with links to papers and other information > to help you get started. > > Best, > Ista > > On Mon, Mar 29, 2010 at 3:15 PM, wclapham <[hidden email] > <http://n4.nabble.com/user/SendEmail.jtp?type=node&node=1695531&i=0> > <http://n4.nabble.com/user/SendEmail.jtp?type=node&node=1695531&i=0> > > wrote: > >> > >> > I have a data frame that I created using read.table on a csv spreadsheet. >> > The data look like the following: >> > >> > Steer.ID stocker.trt Finish.trt Date Days Wt ...... >> > >> > Steer.Id, stocker.trt, Finish.trt are factors------ Date, Days, Wt are data >> > that are repeated 23 times (wide format). >> > >> > I want to reshape the data such that I have the correct Steer.ID, >> > stocker.trt, Finish.trt identifying all of the repeated measures data in a >> > long format. >> > >> > I am a newbie at R and need to develop the skill in reshaping data, so that >> > I can handle routine problems like described above. >> > >> > Thanks so much in advance for help or advice. >> > >> > Bill >> > -- >> > View this message in context: >> http://n4.nabble.com/Reshaping-a-data-frame-with-a-series-of-factors-and-23-r >> epeated-measures-tp1695500p1695500.html >> > Sent from the R help mailing list archive at Nabble.com. >> > >> > ______________________________________________ >> > [hidden email] >> <http://n4.nabble.com/user/SendEmail.jtp?type=node&node=1695531&i=1> >> <http://n4.nabble.com/user/SendEmail.jtp?type=node&node=1695531&i=1> >> mailing list >> > https://stat.ethz.ch/mailman/listinfo/r-help >> > PLEASE do read the posting guide >> http://www.R-project.org/posting-guide.html >> > and provide commented, minimal, self-contained, reproducible code. >> > > >-- View this message in context: http://n4.nabble.com/Reshaping-a-data-frame-with-a-series-of-factors-and-23-repeated-measures-tp1695500p1745223.html Sent from the R help mailing list archive at Nabble.com. [[alternative HTML version deleted]]