How to sum up unique arrays in the matrix
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Moe
am 4 Apr. 2016
Bearbeitet: Azzi Abdelmalek
am 4 Apr. 2016
Hi everyone,
Suppose the matrix A is as follows:
A = [10 1 180
10 1 40
10 1 40
10 1 160
10 2 10
10 3 410
10 1 10
10 1 50
12 1 30
12 1 30
12 2 45
12 3 60
65 1 15
65 1 360
];
I want to sum up the values in column three if the value in column one and two are similar. The output matrix should be like:
B = [10 1 420
10 2 10
10 3 410
10 1 60
12 1 60
12 2 45
12 3 60
65 1 375
];

0 Kommentare
Akzeptierte Antwort
Azzi Abdelmalek
am 4 Apr. 2016
Bearbeitet: Azzi Abdelmalek
am 4 Apr. 2016
Edit
A = [10 1 180
10 1 40
10 1 40
10 1 160
10 2 10
10 3 410
10 1 10
10 1 50
12 1 30
12 1 30
12 2 45
12 3 60
65 1 15
65 1 360
];
idx=any([0 0;diff(A(:,1:2))],2)
jdy=cumsum(idx)
b=accumarray(jdy+1,1:numel(jdy),[],@(x) sum(A(x,3)))
[ii,jj,kk]=unique(jdy)
out=[A(jj,1:2) b]
0 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Creating and Concatenating Matrices finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!