Incomplete time series: Fill missing dates with NaNs

3 次查看（过去 30 天）
pavlos
pavlos 2016-1-3
评论： pavlos 2016-1-3
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

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

回答（1 个）

Andrei Bobrov
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');
  1 个评论
pavlos
pavlos 2016-1-3
The code works perfectly.
Thank you.
But all the seconds are the same, i.e. SS always equals 18.
Also, is it possible to convert "add" to matrix, i.e.: with the following format of columns:
09 01 2013 22 49 18
09 01 2013 23 04 18

请先登录，再进行评论。

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by