Find specific datenum in Matrix

David du Preez

2017 6 8

1 个回答

回答已采纳

3 次查看（30 天）

0 个投票

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更早的评论

请先登录，再进行评论。

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

Follow Question

采纳的回答

David du Preez 2017-6-8

编辑：Andrei Bobrov 2017-6-8

在 MATLAB Online 中打开

0 个投票

% 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