Hi,
Also take a look at cast(), melt() and recast() from the reshape
package. Great and very flexible functions.
cheers,
Paul
Daniel Malter schreef:
?reshape
hth,
Daniel
baxterj wrote:
I am just starting to code in R and need some help as I am used to doing
this in SAS.
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!
______________________________________________
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.
