[R] sorting & subsetting a data.frame

[Liviu Andronic]

On Sun, Mar 6, 2011 at 11:53 PM, Liviu Andronic <landronimirc at gmail.com> wrote:
> On Sun, Mar 6, 2011 at 11:49 PM, Liviu Andronic <landronimirc at gmail.com> wrote:
>> Dear all
>> This may be obvious, but I cannot get it working. I'm trying to subset
>> & sort a data frame in one go.
>> x <- iris
>> x$Species1 <- as.character(x$Species)
>> ##subsetting alone works fine
>> with(x, x[Sepal.Length==6.7,])
>> ##sorting alone works fine
>> with(x, x[order(Sepal.Length, rev(sort(Species1))),])
>> ##gets subsetted, but not sorted as expected
>> with(x, x[(Sepal.Length==6.7) & order(Sepal.Length, rev(sort(Species1))),])
>> ##gets subsetted, but sorts very strangely
>> xa <- with(x, x[Sepal.Length==6.7,]); with(xa, xa[order(Sepal.Length,
>> rev(sort(Species1))),])
>> xa <- with(x, x[Sepal.Length==6.7,]); with(xa, xa[order(rev(sort(Species1))),])
>>
> And of course I found the culprit after sending the e-mail: wrong call
> order. The following does what I want, although it's a bit messy:
> xa <- with(x, x[Sepal.Length==6.7,]); with(xa, xa[rev(order(sort(Species1))),])
> xa <- subset(x, Sepal.Length==6.7); with(xa, xa[rev(order((sort(Species1)))),])
>
But it still doesn't work on my data! Any ideas for a different approach?
Liviu


> Regards
> Liviu
>
>
>> I've checked The R Inferno, Quick-R and several other places with no
>> obvious solution.
>>
>> Any ideas? Regards
>> Liviu
>>
>>
>> --
>> Do you know how to read?
>> http://www.alienetworks.com/srtest.cfm
>> http://goodies.xfce.org/projects/applications/xfce4-dict#speed-reader
>> Do you know how to write?
>> http://garbl.home.comcast.net/~garbl/stylemanual/e.htm#e-mail
>>
>
>
>
> --
> Do you know how to read?
> http://www.alienetworks.com/srtest.cfm
> http://goodies.xfce.org/projects/applications/xfce4-dict#speed-reader
> Do you know how to write?
> http://garbl.home.comcast.net/~garbl/stylemanual/e.htm#e-mail
>



-- 
Do you know how to read?
http://www.alienetworks.com/srtest.cfm
http://goodies.xfce.org/projects/applications/xfce4-dict#speed-reader
Do you know how to write?
http://garbl.home.comcast.net/~garbl/stylemanual/e.htm#e-mail