MATLAB Answers

Comparing two matrix elements summing third and storing them separately

1 view (last 30 days)
Maaz Rao
Maaz Rao on 7 Jul 2019
Answered: Andrei Bobrov on 7 Jul 2019
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
After that i want that the final matriz should be of the form
x = [ 17 20 2
17 25 2
18 18 3
19 17 6]

  0 Comments

Sign in to comment.

Answers (2)

madhan ravi
madhan ravi on 7 Jul 2019
T = array2table(A);
t = groupsummary(T,{'A1','A2'},'sum');
x = t{:,[1,2,end]}

  1 Comment

madhan ravi
madhan ravi on 7 Jul 2019
Or:
[u,~,idx] = unique(A(:,1:2),'rows');
x = [u,accumarray(idx,A(:,3),[],@sum)]

Sign in to comment.


Andrei Bobrov
Andrei Bobrov on 7 Jul 2019
[B,BB] = groupsummary(A(:,3),A(:,1:2),'sum');
out = [BB{:},B];

  0 Comments

Sign in to comment.

Sign in to answer this question.

Products


Release

R2018a