MATLAB: Sorting and averaging matrices

averageMATLABsort

  1. I have two matrices. One for example is A = 520 x 1 and it has numbers from 1-8 which are not in order. For every number in this matrix, I have corresponding 1000 samples in another matrix B 520 x 1000. I want to first sort A and arrange numbers from 1-8 for every 8 rows. So output should be (1,2,3,4,5,6,7,8,1,2,3,4,5 and so on) and arrange corresponding values in B also such that they match.
  2. Once this is done, I want to average every 5 rows of B and store it in a new matrix which will be 104 x 1000.
Thanks for the help in advance!

Best Answer

 [~,idx]=sort(  reshape(A,8,[])  ,1);
 
    [m,n]=size(idx);
  C=reshape(B,m,n,[]);
  
     [m,n,p]=size(C);
  
  idx=idx+(0:n-1)*m+reshape(0:p-1,1,1,p)*(m*n);
  
  C=mean(reshape(C(idx),5,[]));
  
  result=reshape( C  ,m*n/5,[]);
Related Question