comparing two matrix element simultaneously and adding third column

Question

N/A 2019-7-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/470357-comparing-two-matrix-element-simultaneously-and-adding-third-column

评论： N/A 2019-7-7

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

KSSV 2019-7-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/470357-comparing-two-matrix-element-simultaneously-and-adding-third-column#answer_382055

在 MATLAB Online 中打开

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

N/A 2019-7-7

thank you KSSV this works absolutely fine but since my actual matrix is going to be 3x11870 i want that the unique elements and their cumulative sum should be stored separately otherwise it would be too difficult to find them can you tell me how that will work thanks in advance.

请先登录，再进行评论。