Convert daily data to monthly data with missing values.

Hello everyone,

Suppose that I have a daily data but missing some dates as follows. How can I conver the series to a monthly time series. The monthly value is the average daily data available for each month.

29/12/1989 100

04/01/1990 200

05/01/1990 130

01/02/1990 125

09/02/1990 133

12/02/1990 135

Many thanks,

Bao

Answer 1

[KSSV]

You can fill the missing values using fillmissing. You can resample the data using retime

[Bao Nguyen]

Thanks,

Finally, there are a few steps to get the monthly data:

TT = readtimetable('data.csv'); %loading your data
tt = retime(TT, 'daily');  % or
%tt = retime(TT, 'daily', 'previous'); % replace all missing entries with the value from the previous entry.
sum = retime(tt,'Monthly','Sum'); 
average = retime(tt,'Monthly','mean');