Sorting by multiple columns in a table with natural number sorting

10 次查看（过去 30 天）
Centauri Jolene
Centauri Jolene 2019-4-20
评论： Cris LaPierre 2019-4-21
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.

请先登录，再回答此问题。

采纳的回答

Cris LaPierre
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 个评论
显示 1更早的评论
Centauri Jolene
Centauri Jolene 2019-4-21
Thanks. I ran my code line by line and you're right, it seems to be working. I must have been doing something wrong...
The trial numbers are orignially strings ('Trial1', 'Trial2', etc) so I convert the cell array of strings into a character array, and then extract the numbers at the end of each string and finally convert to numbers.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Structures 的更多信息

标签

产品


版本

R2017b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by