On Sun, Mar 6, 2011 at 11:49 PM, Liviu Andronic <landronim...@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)))),])
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 ______________________________________________ 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.
