How to remove leap year dates from time series in data

7 次查看（过去 30 天）
peter huang
peter huang 2022-1-25
评论： peter huang 2022-2-17
How to remove leap year(2/29) dates from time series in data
(My time series is hour by hour)
  3 个评论
显示 1更早的评论
Rik
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
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
Murugan C 2022-1-25
[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);
  3 个评论
显示 1更早的评论
Murugan C
Murugan C 2022-1-27
Please run my code. After that you can open 'removedLeafYear.xlsx' you can see removed leaf year.
Did you run my code.?

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by