How to remove leap year dates from time series in data

9 visualizzazioni (ultimi 30 giorni)
How to remove leap year(2/29) dates from time series in data
(My time series is hour by hour)
  3 Commenti
Rik
Rik il 25 Gen 2022
What did you try? It should be easy enough to test whether a specific datenum or datetime is February 29th.
peter huang
peter huang il 25 Gen 2022
I try many ways However, the data of the 2/29 date could not be successfully removed.
what is specific datenum or datetime ?

Accedi per commentare.

Risposta accettata

Murugan C
Murugan C il 25 Gen 2022
[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 Commenti
Murugan C
Murugan C il 27 Gen 2022
Please run my code. After that you can open 'removedLeafYear.xlsx' you can see removed leaf year.
Did you run my code.?

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Dates and Time in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by