Incomplete time series: Fill missing dates with NaNs
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hello,
I need to fill the missing dates with NaNs.
The format of the data is as follows:
month-day-year-hour-minute-second
09-01-2013-22-19-16
09-01-2013-22-34-17
09-01-2013-22-49-18
% missing data
09-02-2013-07-27-48
09-02-2013-07-42-49
09-02-2013-07-57-50
The metering interval is every 15 minutes so the number of missing data should equal to the number of 15 minute entries that are between
09-01-2013-22-49-18 and 09-02-2013-07-27-48.
Thank you.
Best,
Pavlos
0 commentaires
Réponses (1)
Andrei Bobrov
le 3 Jan 2016
k = datenum(['09-01-2013-22-49-18';'09-02-2013-07-27-48'],'mm-dd-yyyy-HH-MM-SS');
add = datestr(k(1):1/24/4:k(2),'mm-dd-yyyy-HH-MM-SS');
Voir également
Catégories
En savoir plus sur Data Type Conversion dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!