daily max -min , sum, average of hourly data sets.?

Question

pruth 2016-10-19

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/308052-daily-max-min-sum-average-of-hourly-data-sets

编辑： pruth 2016-10-28

hourly.mat

hi,

I have created one mat file (attached). the first column is dates the second column is temperature- here I want to find daily max and min the third column is rainfall- here daily sum I don't need 4th and 5th column but for this time make an average.

in the date column, time is not given but it is an hourly data.(same date 24 times.)

i hope you understand

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

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2016-10-20

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/308052-daily-max-min-sum-average-of-hourly-data-sets#answer_239873

在 MATLAB Online 中打开

[y,m,d] = datevec(tempdata(:,1));
[a,~,c] = unique([y,m,d],'rows');
out = [a, zeros(size(a,1),7)];
out(:,4) = accumarray(c,tempdata(:,2),[],@nanmin);
out(:,5) = accumarray(c,tempdata(:,2),[],@nanmax);
out(:,6) = accumarray(c,tempdata(:,3),[],@nansum);
[ii,jj] = ndgrid(c,1:4);
out(:,7:10) = accumarray([ii(:),jj(:)],reshape(tempdata(:,4:7),[],1),[],@nanmean);

2 个评论
显示无隐藏无

pruth 2016-10-24

thank you sir.

pruth 2016-10-28

编辑：pruth 2016-10-28

sir, what shall I do if want repeats this process after every 3 column?

min max for the first column, the sum of the second column, mean for the third column,

and again action repeats . min max for the fourth column and so on...

请先登录，再进行评论。

Answer 2

Steven Lord 2016-10-19

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/308052-daily-max-min-sum-average-of-hourly-data-sets#answer_239720

If you're using release R2016b or later, I recommend storing your data in a timetable and using the retime function to aggregate data over daily time bins as shown in the second example, "Aggregate Timetable Data and Calculate Mean Values", on that documentation page.