How can I find and put zero for missinf data in a time series?

Question

Andrea 2012-8-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/46435-how-can-i-find-and-put-zero-for-missinf-data-in-a-time-series

Hi all

I have a 30 years of hourly data. Some of the data are missing. It means that I do not have data for example for 1 PM and 2 PM of 12th of JAN. But the missing value are a lot and scattered through the 3 years. How can find them and put zero instead of them in a bigger matrix? I have 5 vectors (years, month, days, hour, values). Some of the hours in some days are missing. We can see them by looking at the data but how can I detect them by MATLAB and increase the size of my matrix by putting zeros instead of them?

I'll appreciate in advance, Andrea

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

per isakson 2012-8-21

Do you really want to replace missing data with zero?

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2012-8-21

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/46435-how-can-i-find-and-put-zero-for-missinf-data-in-a-time-series#answer_56810

在 MATLAB Online 中打开

For each time that you do have, calculate an hour number (an integral value) starting from 1 for the first time-point. Then

ExpandedData = accumarray(HourNumber(:), DataValues(:));

The result will be a column vector in which the row number corresponds to the hour number, and the entry for the row corresponds to the data value for that time, and there are 0's for any missing times.

Note: with the call done this way, if there happen to be multiple entries with the same hour number, the entries would be summed. Changing to calculate the mean instead is quite simple -- add the arguments [], @mean to the call.