Find specific datenum in Matrix

Question

David du Preez 2017-6-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/343902-find-specific-datenum-in-matrix

编辑： Andrei Bobrov 2017-6-8

B.mat
A.mat

Hi. I have a 14x14 (A)matrix.In column 1 are datenum values corresponding to a random hour of a day. I want to use these datenum values to find the hourly data in a much larger matrix(B) and then create a new matrix with the hourly data using the dates from A. So the new matrix should be 336x14

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

请先登录，再进行评论。

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

Answer 1

David du Preez 2017-6-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/343902-find-specific-datenum-in-matrix#answer_270046

编辑：Andrei Bobrov 2017-6-8

在 MATLAB Online 中打开

% extract dates 
dates = datevec(SON_CS2_lowTCO(1:14,1));
% Remove h,m,s
dates = dates(:,1:3);
dates23  = dates;
% Add end of day to matrix
dates23(:,4)=23;
dates23(:,5)=0;
dates23(:,6)=0;
for i=1:14
    findA2 = CS2_All(:,1) >=datenum(dates(i,1:3)) & CS2_All(:,1)<= datenum(dates23(i,1:6));
    A2(24*i-23:24*i,:) = CS2_All(findA2,:);
end