I think you want to look at the command "reshape", it may solve your problem.
Type ?reshape in the R console on your system. On Monday 28 September 2009 18:35:25 Gabor Grothendieck wrote: > > I have a dataset that looks like this: > > > > Chemical Well1 Well2 Well3 Well4 > > BOD 13.2 14.2 15.5 14.2 > > O2 7.8 2.6 3.5 2.4 > > TURB 10.2 14.6 18.5 17.3 > > and so on with more chemicals.... > > > > I would like to transpose my data so that it looks like this: > > Chemical WellID Value > > BOD Well1 13.2 > > BOD Well2 14.2 > > BOD Well3 15.5 > > BOD Well4 14.2 > > O2 Well1 7.8 > > O2 Well2 2.6 > > .... and so on > > > > In sas I would code it like this: > > proc sort data=ds1; by chemical; run; > > Proc Transpose data=ds1 out=ds2; > > by chemical; > > var Well1 Well2 Well3 Well4; > > run; > > data ds3; set ds2; > > rename _name_ = WellID; > > rename col1 = value; > > run; > > > > How can I do this in R?? Any help is much appreciated. Thanks! > > -- > > View this message in context: > > http://www.nabble.com/SAS-user-now-converting-to-R---Help-with-Transpose- > >tp25645393p25645393.html Sent from the R help mailing list archive at > > Nabble.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. > > ______________________________________________ > 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. -- Corrado Topi Global Climate Change & Biodiversity Indicators Area 18,Department of Biology University of York, York, YO10 5YW, UK Phone: + 44 (0) 1904 328645, E-mail: ct...@york.ac.uk ______________________________________________ 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.
