grouping elements of a matix according to an increasing order of dates

Question

antonet 2012-5-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/39335-grouping-elements-of-a-matix-according-to-an-increasing-order-of-dates

Hi all,

i have a matrix A which I have sorted according to the command zoi=sortrows(A, 3 ) and the result is zoi=

         'PDL12'    '01-01-2011'    [     -0.0138]
         'PDL13'    '01-01-2011'    [      0.3529]
         'PDL12'    '01-11-2009'    [     -0.0812]
         'PDL13'    '01-11-2009'    [     -0.2377]
             'PDL12'    '04-10-2009'    [     -0.0208]

And I would like to have

             'PDL12'    '04-10-2009'    [     -0.0208]
         'PDL12'    '01-11-2009'    [     -0.0812]
         'PDL13'    '01-11-2009'    [     -0.2377]
        'PDL12'    '01-11-2009'    [     -0.0812]
         'PDL13'    '01-01-2011'    [      0.3529]

In other words, i want to group all the elements that correspond to the earliest date, then all the elements that correspond to the date after the earliest one and so forth. Any suggestions?

thanks

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

请先登录，再进行评论。

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

Answer 1

Thomas 2012-5-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/39335-grouping-elements-of-a-matix-according-to-an-increasing-order-of-dates#answer_48915

在 MATLAB Online 中打开

a={         'PDL12'    '01-01-2011'    [     -0.0138]
'PDL13'    '01-01-2011'    [      0.3529]
'PDL12'    '01-11-2009'    [     -0.0812]
'PDL13'    '01-11-2009'    [     -0.2377]
'PDL12'    '04-10-2009'    [     -0.0208]}
d=datenum(a(:,2),'dd-mm-yyyy');
[l,idx]=sortrows(d);
a(idx,:)                     % output