Merging Unique Cell Array Elements

Question

matuser123 2016-9-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/302534-merging-unique-cell-array-elements

评论： Star Strider 2016-9-9

I have a cell array with non unique elements and an array with corresponding integer values. I'd like to combine all the repeat cell array values and sum the corresponding array values. Any ideas?

    % Old Data
    descr = {'A','B','C','A','B'}
    value = [2,4,6,-5,8]
    % New Data
    descr = {'A','B','C'}
    value = [-3,12,6]

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2016-9-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/302534-merging-unique-cell-array-elements#answer_234320

在 MATLAB Online 中打开

See if this does what you want:

descr = {'A','B','C','A','B'};
value = [2,4,6,-5,8];
[Uv,~,ref] = unique(descr);
acc = accumarray(ref, value');
Result = table(Uv', acc)
Result = 
      Var1    acc
      ____    ___
      'A'     -3 
      'B'     12 
      'C'      6