Reshape hourly mean values with missing data/ non-uniform data
6 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Walter Roberson
le 11 Mai 2017
Do you have a new enough version of MATLAB that you could switch to timetable() objects instead? R2016b or newer I think it is.
Réponse acceptée
Walter Roberson
le 11 Mai 2017
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];
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Matrices and Arrays 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!