Simplifying an array with repeat values in it
3 views (last 30 days)
Show older comments
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 Comments
Answers (1)
Akira Agata
on 16 Dec 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 Comments
See Also
Categories
Find more on Matrices and Arrays in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!