delete dates from a matrix

Question

elisa ewin 2017-4-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/333309-delete-dates-from-a-matrix

评论： Jan 2017-4-3

I have a matrix of dates [year, month, day, hour, minutes, seconds] ex:

A=[2004 6 18 13 8 0; 2004 7 19 13 45 2; 2004 8 18 13 8 13;2004 8 18 13 9 41;2004 9 18 13 9 50;2005 1 20 13 12 38; 2005 1 17 13 12 45; 2005 2 12 12 12 23; 2005 4 12 12 12 24; 2005 4 12 12 13 49; 2005 12 12 12 13 49; 2005 12 12 12 28 20]

and I want to delete all the dates before (2004 7 22 13 23 11) and after (2005 11 23 12 14 1), can you help me?

I want how result

A=[2004 8 18 13 8 13;2004 8 18 13 9 41;2004 9 18 13 9 50;2005 1 20 13 12 38; 2005 1 17 13 12 45; 2005 2 12 12 12 23; 2005 4 12 12 12 24; 2005 4 12 12 13 49]

thanks

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

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2017-4-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/333309-delete-dates-from-a-matrix#answer_261469

编辑：Andrei Bobrov 2017-4-3

在 MATLAB Online 中打开

A=[2004 6 18 13 8 0;
2004 7 19 13 45 2;
2004 8 18 13 8 13;
2004 8 18 13 9 41;
2004 9 18 13 9 50;
2005 1 20 13 12 38;
2005 1 17 13 12 45;
2005 2 12 12 12 23;
2005 4 12 12 12 24;
2005 4 12 12 13 49;
2005 12 12 12 13 49;
2005 12 12 12 28 20];
tr = [2004 7 22 13 23 11; 2005 11 23 12 14 1];
trn = datenum(tr);
An = datenum(A);
Aout = A(An >= trn(1) & trn(2) >= An,:);

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

请先登录，再进行评论。

Answer 2

KSSV 2017-4-3

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/333309-delete-dates-from-a-matrix#answer_261470

在 MATLAB Online 中打开

A=[2004 6 18 13 8 0; 2004 7 19 13 45 2; 2004 8 18 13 8 13;2004 8 18 13 9 41;2004 9 18 13 9 50;2005 1 20 13 12 38; 2005 1 17 13 12 45; 2005 2 12 12 12 23; 2005 4 12 12 12 24; 2005 4 12 12 13 49; 2005 12 12 12 13 49; 2005 12 12 12 28 20] ;
d0 = [2004 7 22 13 23 11];
d1 = [2005 11 23 12 14 1] ;
Ad = datetime(A) ;
d0d = datetime(d0) ;
d1d = datetime(d1) ;
iwant = Ad(Ad>d0d & Ad < d1d) 
datevec(iwant)

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jan 2017-4-3

在 MATLAB Online 中打开

+1: This uses the modern datetime methods. A simplification:

% Directly instead of datevec(Ad(...))
iwant = A(Ad>d0d & Ad < d1d, :)

请先登录，再进行评论。

Answer 3

Jan 2017-4-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/333309-delete-dates-from-a-matrix#answer_261471

编辑：Andrei Bobrov 2017-4-3

在 MATLAB Online 中打开

A = [2004 6 18 13 8 0; ...
7 19 13 45 2; ...
8 18 13 8 13; ...
8 18 13 9 41; ...
9 18 13 9 50; ...
1 20 13 12 38; ...
1 17 13 12 45; ...
2 12 12 12 23; ...
4 12 12 12 24; ...
4 12 12 13 49; ...
12 12 12 13 49; ...
12 12 12 28 20];
D    = datenum(A);
Keep = datenum([2004 7 22 13 23 11]) <= D & D <= datenum([2005 11 23 12 14 1]);
B    = A(Keep, :);