How to get monthly averages from daily data?
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Muhammad shahid
il 23 Nov 2017
Commentato: Muhammad shahid
il 23 Nov 2017
Hello,
I have an excel file containing 4 column. The first column contain year month day (YEARMODA), the second column contain daily Maximum Temperature (MAX T), the third column contain daily Minimum Temperature (MIN T) and fourth column contain Precipitation data (PRCP). In first column there are missing days for every month its hard to find them one by one. I need monthly average values of MAX T, MIN T and PRCP. The given and required form of data is attached.
0 Commenti
Risposta accettata
KSSV
il 23 Nov 2017
Modificato: KSSV
il 23 Nov 2017
[num,txt,raw] = xlsread('A.xls') ;
date = datevec(num2str(num(:,1)),'yyyymmdd') ;
years = date(:,1) ;
months = date(:,2) ;
%%Get average
[Y,ia,ib] = unique(years) ;
[M,ia,ib] = unique(months) ;
iwant1 = zeros(length(Y),length(M)) ; % Average of max T
iwant2 = zeros(length(Y),length(M)) ; % Average of min T
iwant3 = zeros(length(Y),length(M)) ; % Average of PRCP
for i = 1:length(Y)
idx_Y = years==Y(i) ;
data = num(idx_Y,2:end) ;
YM = months(idx_Y) ;
for j = 1:length(M)
idx_M = YM==M(j) ;
iwant1(i,j) = mean(data(idx_M,1)) ;
iwant2(i,j) = mean(data(idx_M,2)) ;
iwant3(i,j) = mean(data(idx_M,3)) ;
end
end
3 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su ECG / EKG in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!