How to reduce data to categories
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Jeffrey Hawkes
am 27 Jan. 2017
Kommentiert: Jeffrey Hawkes
am 27 Jan. 2017
I have a large double matrix similar to below
testz(1,:)=[325, 325, 325, 269, 369, 369];
testz(2,:)=[3, 2, 5, 2, 6, 9];
and I would like to reduce the data so that the sum of row 2 (3+2+5 and 2+6+9) is shown for each row 1 value, ie.
test_output =
325 369
10 17
How can I do that?! Thanks in advance...
0 Kommentare
Akzeptierte Antwort
the cyclist
am 27 Jan. 2017
Bearbeitet: the cyclist
am 27 Jan. 2017
testz(1,:)=[325, 325, 325, 369, 369, 369];
testz(2,:)=[3, 2, 5, 2, 6, 9];
[uniquez1,~,idx] = unique(testz(1,:)');
sumz2 = accumarray(idx,testz(2,:)');
test_output = [uniquez1,sumz2]'
(It looks like maybe you wrote "269" once, where you meant "369".)
Weitere Antworten (0)
Siehe auch
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!