Please help with using accumarray to choose the max value of the array

I have a matrix, for an example with 11 x 3.

CH BA OL

10.0000 10.0000 0.6000

10.0000 11.0000 0.4000

11.0000 9.0000 0.6000

11.0000 10.0000 0.2000

11.0000 11.0000 0.2000

25.0000 44.0000 0.1000

25.0000 9.0000 0.7000

25.0000 45.0000 0.2000

27.0000 44.0000 0.2000

27.0000 46.0000 0.3000

27.0000 9.0000 0.5000

I'm trying to take unique values for column CH, and each unique value in CH should sort the maximum value's BA. For example, final results should be like

CH BA OL

10 10 0.6

11 9 0.6

25 9 0.7

27 46 0.5

I was trying accumarray but I couldnt get the correct answer. Please help

[Ameer Hamza]

Can you recheck the output matrix? Whether you want the minimum or maximum value from the column BA?

[Hashini Wanniarachchi]

I want to sort by OL, but I need the corresponding BA. So, it max value of OL corresponding to CH 10 is 0.6, the output should have at the end CH 10, BA 10 with OL 0.6. Thank you!

[Ameer Hamza]

In that case, last row should be 27 9 0.5

[Hashini Wanniarachchi]

I apologize for the confusion!

Answer 1

[Mohammad Sami]

% matrix = 11 x 3
ch = matrix(:,1);
[u,~,ic] = unique(ch);
maxba = accumarray(ic,matrix(:,2),[],@max);
out = [u maxba];
i = ismember(matrix(:,1:2),out,'rows');
out = matrix(i,:);

[Hashini Wanniarachchi]

Thank you so much for guidance. Well I wanted to sort through col 3. I sorted it out anyhow following this. Thanks again!

Answer 2

[Ameer Hamza]

Try this

M = [10.0000   10.0000    0.6000
   10.0000   11.0000    0.4000
   11.0000    9.0000    0.6000
   11.0000   10.0000    0.2000
   11.0000   11.0000    0.2000
   25.0000   44.0000    0.1000
   25.0000    9.0000    0.7000
   25.0000   45.0000    0.2000
   27.0000   44.0000    0.2000
   27.0000   46.0000    0.3000
   27.0000    9.0000    0.5000];

[~,idx] = sort(M(:,3));
M = M(idx,:);
[~,idx] = sort(M(:,1));
M = M(idx,:);
result = splitapply(@(x) x(end,:), M, findgroups(M(:,1)));

[Hashini Wanniarachchi]

Thank you so much! Interesting!