How to get monthly averages from daily data?
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
KSSV
2017-11-23
编辑:KSSV
2017-11-23
[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 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 ECG / EKG 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!