How to sum/group values in a matrix based on their index values in first column?!
조회 수: 13 (최근 30일)
이전 댓글 표시
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
댓글 수: 0
채택된 답변
Andrei Bobrov
2014년 9월 28일
[a,~,c] = unique(X(:,1));
out = [a, accumarray(c,X(:,2))];
댓글 수: 2
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!