Merging cells,adding contents

14 visualizzazioni (ultimi 30 giorni)
Andreas
Andreas il 17 Nov 2013
Commentato: Andreas il 17 Nov 2013
Hey everyone.! I have some data in this form
'Mary' [ 37]
'Lisa' [ 18]
'George' [ 20]
'Nick' [ 49]
'Mary' [ 24]
'George' [ 4]
'Lisa' [ 36]
(random names with random sequence)and I want to have this
'Mary' [ 61]
'Lisa' [ 54]
'George' [ 24]
'Nick' [ 49]
(not necessarily in this order) Any good ideas? Thank you all..

Risposta accettata

Azzi Abdelmalek
Azzi Abdelmalek il 17 Nov 2013
v={'Mary' [ 37]
'Lisa' [ 18]
'George' [ 20]
'Nick' [ 49]
'Mary' [ 24]
'George' [ 4]
'Lisa' [ 36]}
[a,b,c]=unique(v(:,1),'stable')
n=accumarray(c,[v{:,2}]')
out=[a num2cell(n)]
  1 Commento
Andreas
Andreas il 17 Nov 2013
aaaaamazing. thank you Azzi for your precise and quick answer.

Accedi per commentare.

Più risposte (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by