Re: [R] Simple order() data frame question.

From: Patrick Breheny <patrick.breheny_at_uky.edu>
Date: Thu, 12 May 2011 08:44:07 -0400

On 05/12/2011 08:32 AM, John Kane wrote:
> Clearly, I don't understand what order() is doing and as ususl the help for order seems to only confuse me more. For some reason I just don't follow the examples there. I must be missing something about the data frame sort there but what?
>
> I originally wanted to reverse-order my data frame df1 (see below) by aa (a factor) but since this was not working I decided to simplify and order by bb to see what was haqppening!!
>
> I'm obviously doing something stupid but what?
>
> (df1<- data.frame(aa=letters[1:10],
> bb=rnorm(10)))
> # Order in acending order by bb
> (df1[order(df1[,2]),] ) # seems to work fine
>
> # Order in decending order by bb.
> (df1[order(df1[,-2]),]) # does not seem to work
>

There is a 'decreasing' option described in the help file for 'order' which does what you want:

df1<- data.frame(aa=letters[1:10],bb=rnorm(10)) df1[order(df1[,2],decreasing=TRUE),]

    aa bb

6   f  3.16449690
7   g  2.44362935
8   h  0.80990322
1   a  0.06365513
5   e -0.33932586
9   i -0.52119533
2   b -0.65623164
4   d -0.86918700
3   c -1.86750927
10  j -2.21178676

df1[order(df1[,1],decreasing=TRUE),]

    aa bb

10  j -2.21178676
9   i -0.52119533
8   h  0.80990322
7   g  2.44362935
6   f  3.16449690
5   e -0.33932586
4   d -0.86918700
3   c -1.86750927
2   b -0.65623164
1   a  0.06365513

The expression 'df1[,-2]' removes the second column from df1; clearly not what you want here.

-- 
Patrick Breheny
Assistant Professor
Department of Biostatistics
Department of Statistics
University of Kentucky

______________________________________________
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.
Received on Thu 12 May 2011 - 12:50:36 GMT

This quarter's messages: by month, or sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

All messages

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 12 May 2011 - 13:50:05 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive