How to get monthly averages from daily data?

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.

Answer 1

[KSSV]

[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

[KSSV]

Muhammad Shahid commented: Bundle of Thanks for prompt response and writing this code. Its pity that I am new user of mat lab I just run this code but in iwant, I only got values for one year. In A sheet Ialso mentioned the required format. Can you kindly guide me how to get the values in the required form as mentioned in my uploaded xlsheet

[KSSV]

Edited the answer...

[Muhammad shahid]

Dear KSSV

Bundle of thanks for guidance and spending your time to solve this issue. The provided matlab code worked for me and it saved my time. This code will be very valuable for hydrologists. I will recommend this code if some one is using GHCN precipitation and temperature data for analysis.