Sorting array by datetimes does not work

2021 1 4
1 个回答
更新时间：2021 1 7
4 次查看（30 天）

0 个投票

Hi,
I need to sort my array, notSorted.mat, by datetimes as strings. The code I use for this is the following:
[~, idx] = sort(datenum(notSorted(:,2), 'dd-MM-yyyy HH:mm'), 1, 'ascend');
sorted = notSorted(idx,:);
However, this does not work. Some values are still not correctly sorted. Does anybody know what went wrong?

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

回答（1 个）

Mischa Kim
Mischa Kim 2021-1-4

0 个投票

Convert to and sort the table:
T = sortrows(cell2table(HR_date_time_strings),2)

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

Tycho Maas
Tycho Maas 2021-1-4
编辑：Tycho Maas 2021-1-4
Thanks but this is still not correct. The final rows of the table contain values from November. It currently does the exact same as my code but in stead puts it in a table, so it is still wrong.
Do you maybe know how to fix this?
Mischa Kim
Mischa Kim 2021-1-4
编辑：Mischa Kim 2021-1-4
Right you are.
DT = datetime({HR_date_time_strings{:,2}}','InputFormat','dd-MM-yyyy HH:mm','Format','preserveinput');
T = sortrows(table({HR_date_time_strings{:,1}}',DT(:)),2)
Tycho Maas
Tycho Maas 2021-1-5
This generates the following error:
Error using ones
Too many input arguments.
Error in matlab.internal.builtinhelper.repmat (line 59)
B = A(ones(siz,'int8'));
Error in table (line 324)
varnames = repmat({''},1,numVars);
Error in CGM_data_04_JAN_2021 (line 149)
T = sortrows(table({HR_date_time_strings{:,1}}',DT(:)),2);
Mischa Kim
Mischa Kim 2021-1-5
The code runs fine with R2020b. What release are you working with?
Tycho Maas
Tycho Maas 2021-1-7
It works now, somehow my MATLAB decided that after restarting it worked again...
Thanks!

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Shifting and Sorting Matrices 的更多信息

产品

版本

R2020b

标签

Community Treasure Hunt

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

Start Hunting!

Translated by