table maximum value column

Hi, I have this table

0 0

0 0

0,0100000000000000 0

0,0100000000000000 1

0,0100000000000000 2

0,0200000000000000 0

0,0200000000000000 1

0,0200000000000000 2

but the table that I want is this one

0 0

0.01 2

0.02 2

the second column is the highest value of each number (0 0.01 0.02)

if someone can help me I would really appreciate because I am a little bit stuck in this problem I do not know even how to start to solve it

Thanks in advance for your time

Luca

Answer 1

[Andrei Bobrov]

A=[0  0
0  0
0.0100000000000000  0
0.0100000000000000  1
0.0100000000000000  2
0.0200000000000000  0
0.0200000000000000  1
0.0200000000000000  2];

[g,ii] = findgroups(A(:,1));
out = [ii,splitapply(@max,A(:,2),g)];

or

[ii,~,g] = unique(A(:,1));
out = [ii,accumarray(g,A(:,2),[],@max)];

[Luca cadalo]

it does not work well because I am working with tables :(

[Andrei Bobrov]

Please attach your tables as mat-file.

[Andrei Bobrov]

A=[0 0
0 0
0.0100000000000000 0
0.0100000000000000 1
0.0100000000000000 2
0.0200000000000000 0
0.0200000000000000 1
0.0200000000000000 2];
A= num2cell(A,1);
T = table(A{:},'va',{'x','y'});

%solution

T_out = varfun(@max,T,'group','x');