Sort a table with different orders for different columns

Question

0 个投票

Assume table A:

A = [
    'k' 2 4
    'a' 3 8
    'a' 4 5
    'k' 2 2
    'a' 3 16
    'k' 9 3
    'k' 9 8
    'a' 4 6
    ]

If i use sortrows(A) every column is sorted with ascending order:

A = [
    'a' 3 8
    'a' 3 16
    'a' 4 5
    'a' 4 6
    'k' 2 2
    'k' 2 4
    'k' 9 3
    'k' 9 8
    ]

Is there a way to sort rows, so first and second column is sorted with ascending order, but third one with descending? I want to get something like this:

A = [
    'a' 3 16
    'a' 3 8
    'a' 4 6
    'a' 4 5
    'k' 2 4
    'k' 2 2
    'k' 9 8
    'k' 9 3
    ]

3 个评论
显示 1更早的评论隐藏 1更早的评论

Karol Buchajczuk 2021-3-31

I want to sort by first column in ascending order, then second in ascending order, then third in descending, so like in example, sortrows is sorting first column, so 'a's are before the 'k's, then for every 'a' it sorts second column, so 'a' 3 is before 'a' 4 etc. My problem is sortrows sorts it by (asc,asc,asc) and I want it sorted by (asc,asc,desc).