How to sum/group values in a matrix based on their index values in first column?!

4 次查看（过去 30 天）
Mohammed
Mohammed 2014-9-28
评论： Jonathan 2019-2-27
I have the following 2-D array and would like to sum the values in second column based on their index values in frist column. Please Note that I don't want to pre-define a vector of index values!
Any Ideas? Thanks!
X =
0 1
100 89
0 2
50 24
100 140
0 11
33 72
67 317
100 209

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2014-9-28
[a,~,c] = unique(X(:,1));
out = [a, accumarray(c,X(:,2))];
  2 个评论
Jonathan
Jonathan 2019-2-27
I went from a sparse matrix representation followed by a summation, to your solution and it is tens of times faster!
Previous implementation:
ValueReps = sparse(rows_i,cols_j,values(cols_j))
out = sum(ValueReps,2);
Great solution! Very efficient!

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by