Incomplete time series: Fill missing dates with NaNs
3 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(1 个)
Andrei Bobrov
2016-1-3
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');
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!