Reshape hourly mean values with missing data/ non-uniform data

1 次查看（过去 30 天）
Venkata
Venkata 2017-5-11
评论： Venkata 2017-5-12
Hi, I could get the hourly averages from minute interval data, using unique and accumarray functions.
I would like to arrange the averaged values in a matrix but there might be some data (hours) missing.
For e.g. my output matrix should look like:
yy mm dd hr1 hr2 hr3 ... 0 0 0 hr20 ... 0
yy mm dd 0 0 0 ... hr10 ..... 0 0 hr24
Is there a way to identify the missing hours data and put zeros there and to create this matrix...!
Thank you.
  2 个评论
Walter Roberson
Walter Roberson 2017-5-11
Do you have a new enough version of MATLAB that you could switch to timetable() objects instead? R2016b or newer I think it is.

请先登录，再进行评论。

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

采纳的回答

Walter Roberson
Walter Roberson 2017-5-11
Supposing that T is a vector of datenum for each reading (the timestamp) and D is the corresponding value, then
dv = datevec(T);
days = datenum([dv(:,1), dv(:,2), dv(:,3)]);
[unique_days, uidxa, uidxc] = unique(days);
hours = dv(:,4);
summary_data = accumarray( [uidxc, hours+1], D(:), [], @mean);
summary_table = [dv(uidxa,1:3), summary_data];

更多回答（0 个）

类别

在 Help Center 和 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