[R] how to rearrange a dataframe

Peter Alspach Peter.Alspach at plantandfood.co.nz
Wed Feb 24 01:32:40 CET 2010


Tena koe Laura

temp <- yourData[(yourData[,1]==1 & yourData[,2]=='-') |
(yourData[,1]==2 & yourData[,2]=='+'),6]

Then use similar subsetting to put column 4 into 6, and then temp into
column 4.  If you don't want to use the intermediary temp then you can
use the construct

a <- a+b
b <- a-b
a <- a-b

HTH ....

Peter Alspach

> -----Original Message-----
> From: r-help-bounces at r-project.org 
> [mailto:r-help-bounces at r-project.org] On Behalf Of Laura 
> Rodriguez Murillo
> Sent: Wednesday, 24 February 2010 11:28 a.m.
> To: r-help at r-project.org
> Subject: [R] how to rearrange a dataframe
> 
> Hi all,
> 
> I'd appreciate if anyone can help me with this...
> 
> I have a data frame that looks like this:
> 
> 1 + name1 1 2 3
> 2 + name2 5 9 10
> 2 - name3 56 74 93
> 1 - name4 65 75 98
> 
> I need to rearrange this in a way so that the rows with  "1" 
> in the first column, and "-" in the second column; then 
> columns 4 and 6 should switch places. That is, column 6 would 
> be now column 4 and column 4 would be column 6 (column 5 
> should stay as column 5) In the same way, if the first column 
> is "2" and the second is "+", then the same rearrangement 
> should be done.
> Rows with the first two entries 1 + or 2 - should stay in the 
> same order.
> This should be done for each row independently.
> 
> Thanks a lot for your help!
> 
> ______________________________________________
> 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.
> 



More information about the R-help mailing list