Removing of duplicates from first column and summing of elements in second column

Question

Banjo 2017-12-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/375081-removing-of-duplicates-from-first-column-and-summing-of-elements-in-second-column

评论： Star Strider 2017-12-31

Dear All,

I need your help as I am not sure how to solve this problem. Namely, from a matrix with N rows and 2 columns, for example:

I want to get new matrix where in the first column will be shown only unique values, and in the second column (in those rows where were duplicates in the first column) will be shown sum of values of second column.

Result:

I hope I was clear enough.

Thank you in advance.

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2017-12-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/375081-removing-of-duplicates-from-first-column-and-summing-of-elements-in-second-column#answer_298227

在 MATLAB Online 中打开

This works:

[Xu1,~,Ic2] = unique(X(:,1), 'stable');
Tally = accumarray(Ic2, X(:,2));
Y = [Xu1 Tally]
Y =
     1     2
     2     3
     3     4
     4     6
     5     5
     6     9