Convert daily data to monthly data with missing values.

2022 5 18
1 个回答
回答已采纳
更新时间：2022 5 19
11 次查看（30 天）

0 个投票

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

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

 采纳的回答

KSSV
KSSV 2022-5-18

0 个投票

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

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

Bao Nguyen
Bao Nguyen 2022-5-19
编辑：KSSV 2022-5-19
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');

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by