actually, clones.info[order(clones.info$CHROMOSOME, clones.info$KB_POSITION),]
btw, documented in the help file. b On Nov 18, 2007, at 1:54 PM, Henrique Dallazuanna wrote: > clones.info[order(clones.info$CHROMOSOME),] > > -- > Henrique Dallazuanna > Curitiba-Paraná-Brasil > 25° 25' 40" S 49° 16' 22" O > > > On 18/11/2007, affy snp <[EMAIL PROTECTED]> wrote: >> Dear list, >> >> I have a data frame (238304 rows and 6 columns). I want the data >> frame >> sorted by two columns in ascending order. I am showing >> the first 5 rows of the data frame >> >>> clones.info[1:5,1:6] >> USER_CLONE_ID CHROMOSOME Expr1002 KB_POSITION Allele_A WELL_ID >> 1 SNP_A-1855402 17 41419603 41419603 C rs17572851 >> 2 SNP_A-4249904 17 41420045 41420045 A rs17572893 >> 3 SNP_A-2174835 18 41407760 41407760 C rs17651213 >> 4 SNP_A-1880271 18 41173993 41173993 A rs17563827 >> 5 SNP_A-2313232 17 41169023 41169023 C rs17563787 >> >> Especially, I want the data frame sorted by column CHROMOSOME >> first and then by KB_POSITION. Both in ascending orders. >> >> So after sorting, it should looks like: >>> clones.info[1:5,1:6] >> USER_CLONE_ID CHROMOSOME Expr1002 KB_POSITION Allele_A WELL_ID >> 1 SNP_A-2313232 17 41169023 41169023 C rs17563787 >> 2 SNP_A-1855402 17 41419603 41419603 C rs17572851 >> 3 SNP_A-4249904 17 41420045 41420045 A rs17572893 >> 4 SNP_A-1880271 18 41173993 41173993 A rs17563827 >> 5 SNP_A-2174835 18 41407760 41407760 C rs17651213 >> >> I looked at the R manual and found order() can be used to sort a >> vector or data frame but only for one vector. Is it possible to >> sort by two columns using order() or some other functions in >> R? >> >> Thanks a lot! >> Allen >> >> [[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. >> > > ______________________________________________ > 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.
