Skip to content
Prev 181606 / 398502 Next

Sort matrix by column 1 ascending then by column 2 decending

On 5/27/2009 8:39 AM, Paul Geeleher wrote:
You've seen a few ways.  Here are some more:

1.  Use the fact that order() uses a stable sort algorithm, so just sort 
by the second column then the first:

x <- matrix(c(2,1,1,3,.5,.3,.5,.2), ncol=2)
x1 <- x[order(x[,2], decreasing=TRUE),]
x2 <- x1[order(x1[,1]),]
x2

2.  Use the fact that your values are numeric, so negatives sort in the 
reverse order of positives:

x[order(x[,1], -x[,2]),]

3.  If the values aren't known to be numeric, convert them to numeric 
before using them as sort keys:

x[order(xtfrm(x[,1]), -xtfrm(x[,2])),]

In any of these, watch out for NA handling.  My methods all put NA 
values last, but that might not be what you want.

Duncan Murdoch