Convert daily data to monthly data with missing values.

Question

Bao Nguyen 2022-5-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1721880-convert-daily-data-to-monthly-data-with-missing-values

编辑： KSSV 2022-5-19

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

KSSV 2022-5-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1721880-convert-daily-data-to-monthly-data-with-missing-values#answer_966190

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Bao Nguyen 2022-5-19

编辑：KSSV 2022-5-19

在 MATLAB Online 中打开

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