Help with findgroups command

Question

Qiana Curcuru 2021-7-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/881948-help-with-findgroups-command

回答： Akira Agata 2021-7-20

采纳的回答： Akira Agata

在 MATLAB Online 中打开

I want to sum the first 3 values in the second column for each category.

For example, in this case I want the result to be:

apples: 4

orange: 2

I have the following code and i can't get it to work. Thanks!

a={'apples' 1 2;
  'orange' 2 3;
  'apples' 3 4;
  'Pear'   4 5;
  'apples' 5 6;}
[G,fields]=findgroups(a(:,1));
a(1:3)
G(1:3)
b=a(:,2)
X=splitapply(@sum, b ,G);

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Akira Agata 2021-7-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/881948-help-with-findgroups-command#answer_750188

在 MATLAB Online 中打开

Like this?

a = {...
  'apples' 1 2;...
  'orange' 2 3;...
  'apples' 3 4;...
  'Pear'   4 5;...
  'apples' 5 6;};
% Extract the first 3 items
a2 = a(1:3,:);
% Apply findgroups
[G, fields] = findgroups(a2(:,1));
% Execute splitapply
x = splitapply(@sum, cell2mat(a2(:,2)), G);
% Summarize the result
tResult = table(fields, x,...
  'VariableNames',{'Item','Value'});
% Show the result
disp(tResult)
       Item       Value
    __________    _____

    {'apples'}      4  
    {'orange'}      2  