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

3 次查看（过去 30 天）
pruth
pruth 2016-10-19
编辑： pruth 2016-10-28
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

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2016-10-20
[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
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...

请先登录，再进行评论。

更多回答（1 个）

Steven Lord
Steven Lord 2016-10-19
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.

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by