[R] Sort help
Geneset_name #Chromosome #Hit_in_Biomart original_geneset_len Missing.genes [1,] "AGUIRRE_PANCREAS_CHR12" "1" "51" "59" "8" [3,] "AGUIRRE_PANCREAS_CHR9" "1" "24" "24" "0" [4,] "AGUIRRE_PANCREAS_CHR1""1" "30" "31" "1" [5,] "AGUIRRE_PANCREAS_CHR18" "1" "17" "17" "0" [6,] "AGUIRRE_PANCREAS_CHR7" "1" "35" "48" "13" [7,] "AGUIRRE_PANCREAS_CHR8" "1" "55" "61" "6" Above is a dataframe information. i need to sort the entire dataframe based on the 3rd colum. in decending order. I tried using order information[order(information[,3])] but it gives me only the ordered first coulmn that too i am not sure that it really works. Kindly let me know with any suggestions. Regards Ramya -- View this message in context: http://www.nabble.com/Sort-help-tp20346314p20346314.html Sent from the R help mailing list archive at Nabble.com. __ 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.
Re: [R] Sort help
Hi Ramya, You're almost there. Just specify that you want to order all the data set based-on the third column. Here is an example: # Data information=data.frame( geneset=letters[1:7], chromosome=1, hit=c(51,24,30,17,35,55,61)) # New data information[order(information[,3],decreasing=TRUE),] HTH, Jorge On Wed, Nov 5, 2008 at 2:02 PM, Rajasekaramya <[EMAIL PROTECTED]>wrote: > > Geneset_name #Chromosome #Hit_in_Biomart > original_geneset_len Missing.genes > [1,] "AGUIRRE_PANCREAS_CHR12" "1" "51" > "59" "8" > [3,] "AGUIRRE_PANCREAS_CHR9" "1" "24" > "24" "0" > [4,] "AGUIRRE_PANCREAS_CHR1""1" "30" > "31" "1" > [5,] "AGUIRRE_PANCREAS_CHR18" "1" "17" > "17" "0" > [6,] "AGUIRRE_PANCREAS_CHR7" "1" "35" > "48" "13" > [7,] "AGUIRRE_PANCREAS_CHR8" "1" "55" > "61" "6" > > Above is a dataframe information. > > i need to sort the entire dataframe based on the 3rd colum. in decending > order. > > I tried using order > > information[order(information[,3])] but it gives me only the ordered first > coulmn that too i am not sure that it really works. > > Kindly let me know with any suggestions. > > Regards > Ramya > > > -- > View this message in context: > http://www.nabble.com/Sort-help-tp20346314p20346314.html > Sent from the R help mailing list archive at Nabble.com. > > __ > 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]] __ 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.
Re: [R] Sort help
http://www.ats.ucla.edu/stat/R/faq/sort.htm
A great tutorial about sorting data in R.
HTH,
_
Patrick Richardson
Biostatistician - Program of Translational Medicine
Van Andel Research Institute - Webb Lab
Grand Rapids, MI 49503
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rajasekaramya
Sent: Wednesday, November 05, 2008 2:03 PM
To: r-help@r-project.org
Subject: [R] Sort help
Geneset_name #Chromosome #Hit_in_Biomart
original_geneset_len Missing.genes
[1,] "AGUIRRE_PANCREAS_CHR12" "1" "51"
"59" "8"
[3,] "AGUIRRE_PANCREAS_CHR9" "1" "24"
"24" "0"
[4,] "AGUIRRE_PANCREAS_CHR1""1" "30"
"31" "1"
[5,] "AGUIRRE_PANCREAS_CHR18" "1" "17"
"17" "0"
[6,] "AGUIRRE_PANCREAS_CHR7" "1" "35"
"48" "13"
[7,] "AGUIRRE_PANCREAS_CHR8" "1" "55"
"61" "6"
Above is a dataframe information.
i need to sort the entire dataframe based on the 3rd colum. in decending
order.
I tried using order
information[order(information[,3])] but it gives me only the ordered first
coulmn that too i am not sure that it really works.
Kindly let me know with any suggestions.
Regards
Ramya
--
View this message in context:
http://www.nabble.com/Sort-help-tp20346314p20346314.html
Sent from the R help mailing list archive at Nabble.com.
__
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.
This email message, including any attachments, is for th...{{dropped:6}}
__
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.
Re: [R] Sort help
The R wiki also discusses this:
http://wiki.r-project.org/rwiki/doku.php?id=tips:data-frames:sort&s=sort
On Wed, Nov 5, 2008 at 1:24 PM, Richardson, Patrick
<[EMAIL PROTECTED]> wrote:
> http://www.ats.ucla.edu/stat/R/faq/sort.htm
>
> A great tutorial about sorting data in R.
>
> HTH,
>
> _
> Patrick Richardson
> Biostatistician - Program of Translational Medicine
> Van Andel Research Institute - Webb Lab
> Grand Rapids, MI 49503
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rajasekaramya
> Sent: Wednesday, November 05, 2008 2:03 PM
> To: r-help@r-project.org
> Subject: [R] Sort help
>
>
> Geneset_name #Chromosome #Hit_in_Biomart
> original_geneset_len Missing.genes
> [1,] "AGUIRRE_PANCREAS_CHR12" "1" "51"
> "59" "8"
> [3,] "AGUIRRE_PANCREAS_CHR9" "1" "24"
> "24" "0"
> [4,] "AGUIRRE_PANCREAS_CHR1""1" "30"
> "31" "1"
> [5,] "AGUIRRE_PANCREAS_CHR18" "1" "17"
> "17" "0"
> [6,] "AGUIRRE_PANCREAS_CHR7" "1" "35"
> "48" "13"
> [7,] "AGUIRRE_PANCREAS_CHR8" "1" "55"
> "61" "6"
>
> Above is a dataframe information.
>
> i need to sort the entire dataframe based on the 3rd colum. in decending
> order.
>
> I tried using order
>
> information[order(information[,3])] but it gives me only the ordered first
> coulmn that too i am not sure that it really works.
>
> Kindly let me know with any suggestions.
>
> Regards
> Ramya
>
>
> --
> View this message in context:
> http://www.nabble.com/Sort-help-tp20346314p20346314.html
> Sent from the R help mailing list archive at Nabble.com.
>
> __
> 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.
> This email message, including any attachments, is for th...{{dropped:6}}
>
> __
> 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.
