Sorry but one more question. After sorting the data frame,
I need to re-organzie the data frame by taking four columns
to create a new data frame (I used cbind). But why the
first two colums of the new data frame are not USER_CLONE_ID,
WELL_ID columns in the previous data frame.

I am attaching the codes.

Thanks a lot!

Allen



> cl<-clones.info[order(clones.info$CHROMOSOME, clones.info$KB_POSITION),]
cl[1:4,1:4]
cl2<-cbind(cl$USER_CLONE_ID,cl$WELL_ID,cl$CHROMOSOME,round(cl$KB_POSITION/1000))
dim(cl2)
cl2[1:4,1:4]> dim(cl)
[1] 238304 6
> cl[1:4,1:4]
USER_CLONE_ID CHROMOSOME Expr1002 KB_POSITION
96169 SNP_A-1909444 1 792429 792429
208574 SNP_A-2237149 1 817376 817376
68192 SNP_A-4303947 1 819185 819185
210152 SNP_A-2236359 1 832343 832343
>
cl2<-cbind(cl$USER_CLONE_ID,cl$WELL_ID,cl$CHROMOSOME,round(cl$KB_POSITION/1000))
> dim(cl2)
[1] 238304 4
> cl2[1:4,1:4]
[,1] [,2] [,3] [,4]
[1,] 43121 132913 1 792
[2,] 149264 178012 1 817
[3,] 237378 142083 1 819
[4,] 149002 130012 1 832
>




On 11/18/07, affy snp <affysnp@gmail.com> wrote:
>
> Thanks all of you. It works.
>
> Have a good weekend!
>
> Allen
>
> On 11/18/07, Benilton Carvalho <bcarvalh@jhsph.edu > wrote:
> >
> > 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 < affysnp@gmail.com> 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.
> >
>
>

	[[alternative HTML version deleted]]

