How about this: > x[order(x$One,-x$Two,decreasing=T),] One Two 8 5 3 7 4 3 6 3 3 4 2 2 5 2 3 3 1 1 1 1 2 2 1 3
2009/6/24 Daniel Brewer <daniel.bre...@icr.ac.uk>: > Hello, > > I have a data.frame which I would like to sort with the primary key > decreasing while the secondry key is increasing e.g. > > x <- data.frame(One=c(1,1,1,2,2,3,4,5),Two=c(2,3,1,2,3,3,3,3)) > > I would like to order it so it looks like this: > > One Two > 8 5 3 > 7 4 3 > 6 3 3 > 4 2 2 > 5 2 3 > 3 1 1 > 1 1 2 > 2 1 3 > > i.e. primarily decreasing in the 1st column but if there is a tie > increasing in the second column. > > Is this possible? I can not find anything in order that seems to > support this. I would have thought, > > x[order(x$One,x$Two,decreasing=c(T,F)),] > > would do it but it doesn't. > > Thanks > > Dan > > -- > ************************************************************** > Daniel Brewer, Ph.D. > > Institute of Cancer Research > Molecular Carcinogenesis > Email: daniel.bre...@icr.ac.uk > ************************************************************** > > The Institute of Cancer Research: Royal Cancer Hospital, a charitable Company > Limited by Guarantee, Registered in England under Company No. 534147 with its > Registered Office at 123 Old Brompton Road, London SW7 3RP. > > This e-mail message is confidential and for use by the a...{{dropped:2}} > > ______________________________________________ > 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. > -- HUANG Ronggui, Wincent PhD Candidate Dept of Public and Social Administration City University of Hong Kong Home page: http://asrr.r-forge.r-project.org/rghuang.html ______________________________________________ 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.