comparing two matrix element simultaneously and adding third column
1 次查看(过去 30 天)
显示 更早的评论
the problem is extension of the question https://www.mathworks.com/matlabcentral/answers/106095-comparing-matrix-elements-and-performing-operation-if-equal
whenever the elemnts in column 1 and 3 both are repeated elsewhere in matrix then only third column should get added up
e.g
A=
18 18 1
17 20 2
18 18 1
17 25 2
19 17 3
18 18 1
19 17 3
then answer should be
18 18 1
17 20 2
18 18 2
17 25 2
19 17 3
18 18 3
19 17 6
0 个评论
采纳的回答
KSSV
2019-7-5
A = [ 18 18 1
17 20 2
18 18 1
17 25 2
19 17 3
18 18 1
19 17 3] ;
[c,ia,ib] = unique(A(:,1:2),'rows') ;
B = A ;
% [c,ia,ib] = unique(A(:,3)) ;
for i = 1:length(c)
B(ib==i,3) = cumsum(A(ib==i,3)) ;
end
B
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Matrix Indexing 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!