Incomplete time series: Fill missing dates with NaNs

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

Answer 1

[Andrei Bobrov]

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');

[pavlos]

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