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-boun...@r-project.org > [mailto:r-help-boun...@r-project.org] On Behalf Of Laura > Rodriguez Murillo > Sent: Wednesday, 24 February 2010 11:28 a.m. > To: r-help@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@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.
