Sorting by multiple columns in a table with natural number sorting
显示 更早的评论
I have a table of data that I want to sort by pair number and by trial number.
The issue is that if I use:
data = sortrows(data, {'pairNum', 'trialNum'}, {'ascend', 'ascend'});
It sorts with trial 10 being before trial 1.
However, if I try and use Stephen Cobeldick's nat sort function, I can't take into account the pair number as well as the trial number so it ends up sorting with all trial 1s, then all trial 2s etc.. (doesnt preserve the order of the pairs).
Is there a way to sort my table so that my pairs go from 1-100, and within those pairs, the trial numbers go from 1-100?
Also, I tried adding zeros to the trial numbers so that it would hopefully sort 01 before 10, but when I convert to a number using str2num and/or str2double, it gets rid of the leading zeros.
data.trialNum = strsplit(sprintf('%02d ',data.trialNum))';
The datatset is attached as a .mat file.
2 个评论
Andrei Bobrov
2019-4-20
Please attach small example your data as mat-file.
Centauri Jolene
2019-4-20
采纳的回答
Cris LaPierre
2019-4-20
编辑：Cris LaPierre
2019-4-20
Here's a simple example that works for me:
pairNum = randi(15,1,200)';
trialNum = randi(15,1,200)';
data=table(pairNum, trialNum)
data = sortrows(data,{'pairNum','trialNum'})
3 个评论
Cris LaPierre
2019-4-20
Sorting ascended is default, so you don't have to specify it.
The data set you shared does not contain a trialNum == 1. You also talk about having to use str2num (better to use str2double). Could you include a raw data set? Even when I convert the numbers to strings, I don't observe the behavior you describe.
How are you loading your data into MATLAB? If using readtable or the import tool, you can specify the column data type, which means you can import your numbers as numbers, not strings, bypassing this whole issue.
Centauri Jolene
2019-4-21
Cris LaPierre
2019-4-21
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Shifting and Sorting Matrices 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
