How to take monthly of time series using loop I am having data form each month( having 30/31) data values
    3 views (last 30 days)
  
       Show older comments
    
How to take monthly average from each month using loop, and in one year there should be 12 values
2 Comments
  Adam
      
      
 on 17 Sep 2014
				Give an example of what your inputs look like otherwise it is impossible to answer. There aren't any prizes for the shortest "question" statement on the forum!
Answers (2)
  Andrei Bobrov
      
      
 on 18 Sep 2014
        
      Edited: Andrei Bobrov
      
      
 on 18 Sep 2014
  
      load yourdata.mat
[ym,~,c] = unique(a(:,1:2),'rows');
s = size(a)-[0,3];
ii = repmat(c,s(2),1);
jj = repmat(1:s(2),s(1),1);
out = [ym,accumarray([ii,jj(:)],reshape(a(:,4:end),[],1),[],@mean)];
0 Comments
See Also
Categories
				Find more on Loops and Conditional Statements in Help Center and File Exchange
			
	Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!


