Hi BJ, Is this what you want?
Data1 <- structure(list(Site = structure(c(1L, 1L, 1L, 1L, 2L, 2L, 2L, 2L), .Label = c("Site1", "Site2"), class = "factor"), Fish_no = structure(c(1L, 2L, 3L, 4L, 1L, 2L, 3L, 4L), .Label = c("Fish1", "Fish2", "Fish3", "Fish4"), class = "factor"), Length = c(10L, 13L, 14L, 15L, 5L, 8L, 7L, 9L)), .Names = c("Site", "Fish_no", "Length"), class = "data.frame", row.names = c(NA, -8L)) require(reshape2) dcast(Data1, Fish_no ~ Site, value_var = "Length") HTH, Josh On Mon, Aug 8, 2011 at 8:47 AM, B Jessop <deel...@hotmail.com> wrote: > > Help-list, > > > > Sorry about the formatting problem, Josh. The following example data > set(minor difference from original) in plain text should make the problem > clear. > > > > Original data format: > Site Fish_no Length > Site1 Fish1 10 > Site1 Fish2 13 > Site1 Fish3 14 > Site1 Fish4 15 > ………. > Site2 Fish1 5 > Site2 Fish2 8 > Site2 Fish3 7 > Site2 Fish4 9 > …….. > Site and Fish are factors, Length is a numeric variable. There are 15 cases > for each Site group. The objective is to reshape to: > Site1 Site2 > 10 5 > 13 8 > 14 7 > 15 9 > Etc. > The following code works inadequately: > Df2 <- dcast (Data1, Length ~ Site, value_var = “Length”) > > > It produces the following: > Length Site1 Site2 > 10 10 NA > 13 13 NA > 14 14 NA > 15 15 NA > …….. > 5 NA 5 > 8 NA 8 > 7 NA 7 > …….. > > > > Thanks for any suggestions. > > > > Regards, > > BJ > ---------------------------------------- >> Date: Sun, 7 Aug 2011 18:27:49 -0700 >> Subject: Re: [R] Help on reshape2 data frame rearrangement >> From: jwiley.ps...@gmail.com >> To: deel...@hotmail.com >> CC: r-help@r-project.org >> >> Hi BJ, >> >> Suppose that your data set is called 'Data1', please copy and paste >> the output created by typing: >> >> dput(Data1[1:15, ]) >> >> and post that to the list ***in plain text*** (or upload a text file >> on some file hosting service). The email you sent is nearly >> impossible to parse because this is a plain text list (as noted in the >> posting guide) and your html formatting is utterly lost. >> >> Josh >> >> On Sun, Aug 7, 2011 at 6:19 PM, B Jessop <deel...@hotmail.com> wrote: >> > >> > >> > Dear help list: I am trying to reshape a data frame from long to wide >> > format and with a reduced variable list using reshape2. The original data >> > frame format is: > > Site Obs_no Length > > Site 1 Obs 1 10 > > Site 1 Obs 2 13 > > Site 1 Obs 3 14 > > ......... > > Site 2 Obs 1 5 > > Site 2 Obs 2 7 > > Site 2 Obs 3 9 > > > > Site and Obs_no are factors and Length is a numeric variable. There are 15 > cases in each Site group. The objective is to rearrange to: > > Site 1 Site 2 > > 10 5 > > 13 7 > > 14 9 > > ........ > > I have tried a variety of approaches, none of which worked. The following > code does not work but suggests the task might be possible, perhaps in 2 > steps. > > Df2 <- dcast (Data1, Length ~ Site, value_var = "Length") Its output is: > > Length Site 1 Site2 > > 10 10 NA > > 13 13 NA > > 14 14 NA > > ....... > > 5 NA 5 > > 7 NA 7 > > 9 NA 9 > > > > [[elided Hotmail spam]] >> > r use but I would like to do it in R. Any suggestions would be much >> > appreciated. Regards,BJ >> > [[alternative HTML version deleted]] >> ^^^^^^^^^^^^^^^^^^^^^^^^^^^ >> > >> > ______________________________________________ >> > R-help@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. >> > >> >> >> >> -- >> Joshua Wiley >> Ph.D. Student, Health Psychology >> Programmer Analyst II, ATS Statistical Consulting Group >> University of California, Los Angeles >> https://joshuawiley.com/ > ______________________________________________ > R-help@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. > -- Joshua Wiley Ph.D. Student, Health Psychology Programmer Analyst II, ATS Statistical Consulting Group University of California, Los Angeles https://joshuawiley.com/ ______________________________________________ R-help@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.