Simplifying an array with repeat values in it
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have an array with repeated values in it. I want to simply the array so there are no repeat values in column 1 while also summing the associated values in column 3. Attached is an excel spreadsheet of the inputs and outputs of what I want the array to look like. I am aware of sort, unique, and accumarray but I am having trouble putting it all together.
0 commentaires
Réponses (1)
Akira Agata
le 16 Déc 2019
How about the following?
load('data.mat');
[g,tbl] = findgroups(data(:,{'partnumber','description'}));
QYT = splitapply(@sum,data.QTY,g);
tbl.QYT = QYT;
>> tbl
tbl =
4×3 table
partnumber description QYT
__________ _____________ ___
100 "resistor" 3
200 "capacitor" 3
300 "inductor" 1
400 "transformer" 8
0 commentaires
Voir également
Catégories
En savoir plus sur Matrices and Arrays dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!