table maximum value column

1 次查看（过去 30 天）
Luca cadalo
Luca cadalo 2017-6-18
编辑： Andrei Bobrov 2017-6-19
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

请先登录，再回答此问题。

采纳的回答

Andrei Bobrov
Andrei Bobrov 2017-6-18
编辑：Andrei Bobrov 2017-6-18
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)];
  3 个评论
显示 1更早的评论
Andrei Bobrov
Andrei Bobrov 2017-6-19
Please attach your tables as mat-file.
Andrei Bobrov
Andrei Bobrov 2017-6-19
编辑：Andrei Bobrov 2017-6-19
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');

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by