How to remove leap year dates from time series in data

3 次查看（过去 30 天）

显示更早的评论

peter huang 2022-1-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1635775-how-to-remove-leap-year-dates-from-time-series-in-data

评论： peter huang 2022-2-17

采纳的回答： Murugan C

moving_windown_test.xlsx

How to remove leap year(2/29) dates from time series in data

(My time series is hour by hour)

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

Rik 2022-1-25

What did you try? It should be easy enough to test whether a specific datenum or datetime is February 29th.

peter huang 2022-1-25

I try many ways However, the data of the 2/29 date could not be successfully removed.

what is specific datenum or datetime ?

请先登录，再进行评论。

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

采纳的回答

Murugan C 2022-1-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1635775-how-to-remove-leap-year-dates-from-time-series-in-data#answer_881455

在 MATLAB Online 中打开

[numDat,txtDat,rawDat] = xlsread('moving_windown_test.xlsx');
leafYecount = 1;
for i1 = 1 : size(rawDat,1)
    str_data = num2str(rawDat{i1,1});
    f = datetime(str2double(str_data(1:4)),str2double(str_data(5:6)),str2double(str_data(7:end)));
    fe = datestr(f,'dd/mm');
    if strcmp(fe,'29/02')
        disp(['Leaf Year ' datestr(f)]);
        leafYe(leafYecount) = i1;
        leafYecount = leafYecount + 1;
    end
end
rawDat(leafYe',:) = [];
xlswrite('removedLeafYear',rawDat);