Hi,
I edit the question: I have matrix M with six columns and n rows:
M = [HomeID, WorkID, SchoolID, ShopID, timeS, timeP];for example (lets say it is already sorted):M = [101, 201, 301, 401, 5.46, 7.83; 101, 201, 301, 401, 3.63, 4.52; 101, 201, 301, 401, 2.785, 2.99; 102, 205, 301, 401, 3.53, 8.5; 102, 205, 301, 402, 3.48, 8.9];
I want to make it in the form of:
M2 = [101, 201, 301, 401, 3.958, 5.113; 102, 205, 301, 401, 3.53, 8.5; 102, 205, 301, 402, 3.48, 8.9];
I want to make calculation for each unique pair of SchoolID-WorkID combination within each unique pair of HomeID-WorkID combination and produce a matrix which will have no multiple Home-Work-School-Shop registers but the unique ones with the average values instead [M2(1,4)=(M(1,4)+M(2,4)+M(3,4))/3].
Thanks,
Iro
Best Answer