Merging Unique Cell Array Elements

2 Ansichten (letzte 30 Tage)
matuser123
matuser123 am 9 Sep. 2016
Kommentiert: Star Strider am 9 Sep. 2016
I have a cell array with non unique elements and an array with corresponding integer values. I'd like to combine all the repeat cell array values and sum the corresponding array values. Any ideas?
% Old Data
descr = {'A','B','C','A','B'}
value = [2,4,6,-5,8]
% New Data
descr = {'A','B','C'}
value = [-3,12,6]

Akzeptierte Antwort

Star Strider
Star Strider am 9 Sep. 2016
See if this does what you want:
descr = {'A','B','C','A','B'};
value = [2,4,6,-5,8];
[Uv,~,ref] = unique(descr);
acc = accumarray(ref, value');
Result = table(Uv', acc)
Result =
Var1 acc
____ ___
'A' -3
'B' 12
'C' 6
The table output is optional, and just shows the result.
  2 Kommentare
matuser123
matuser123 am 9 Sep. 2016
Thanks!
Star Strider
Star Strider am 9 Sep. 2016
My pleasure!

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Resizing and Reshaping 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!

Translated by