Sort a matrix with respect to a date.

Question

Marty Dutch 2015-9-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/243537-sort-a-matrix-with-respect-to-a-date

编辑： Stephen23 2015-9-17

Hi experts, is there a way to sort variables in a matrix based on date? For instance, here I want to first sort the variables based on column 3 (0s first then 1s) and then based on date (earliest dates first). See for an example below.

list = 
      {3436x1 cell}    [3436x11 char]  [3436x1 double]
      'BG4704_01'   03-Jan-2015  0
      'BG4705_01'       02-Jan-2015  1
      'BG4706_01'  21-Dec-2014  0
      'BG4707_01'  23-Oct-1913  1
      'BG4708_01'  05-Jul-1913  1

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Stephen23 2015-9-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/243537-sort-a-matrix-with-respect-to-a-date#answer_192707

编辑：Stephen23 2015-9-17

在 MATLAB Online 中打开

Probably the easiest way is to simply convert those date strings to date numbers, which can then be sorted together with the binary values:

% original data in X
X{1} = {'BG4704_01';'BG4705_01';'BG4706_01';'BG4707_01';'BG4708_01'};
X{2} = ['03-Jan-2015';'02-Jan-2015';'21-Dec-2014';'23-Oct-1913';'05-Jul-1913'];
X{3} = [0;1;0;1;1];
% create numeric matrix Y and sort based on binary then dates: 
Y(:,2) = datenum(X{2},'dd-mmm-yyyy');
Y(:,1) = X{3};
[~,idx] = sortrows(Y)
% rearrange data inside cell vector X
for k = 1:numel(X)
    X{k} = X{k}(idx,:);
end