daily max -min , sum, average of hourly data sets.?
6 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
Andrei Bobrov
le 20 Oct 2016
[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 commentaires
Plus de réponses (1)
Steven Lord
le 19 Oct 2016
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.
Voir également
Catégories
En savoir plus sur Timetables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!