Drexel dragonThe Math ForumDonate to the Math Forum

Search All of the Math Forum:

Views expressed in these public forums are not endorsed by Drexel University or The Math Forum.

Math Forum » Discussions » Software » comp.soft-sys.matlab

Topic: how to find unique rows and calculate the average.
Replies: 9   Last Post: Apr 12, 2013 6:31 PM

Advanced Search

Back to Topic List Back to Topic List Jump to Tree View Jump to Tree View   Messages: [ Previous | Next ]
Bruno Luong

Posts: 9,240
Registered: 7/26/08
Re: how to find unique rows and calculate the average.
Posted: Apr 11, 2013 2:38 AM
  Click to see the message monospaced in plain text Plain Text   Click to reply to this topic Reply

>> c = {'3BAB38287PAPU' 234
'3BAB38287POLA' 456
'3BAB38287GAAF' 35
'3BAB38287PAPU' 232
'3BAB38287POLA' 406
'3BAB38287GAAF' 29}

c =

'3BAB38287PAPU' [234]
'3BAB38287POLA' [456]
'3BAB38287GAAF' [ 35]
'3BAB38287PAPU' [232]
'3BAB38287POLA' [406]
'3BAB38287GAAF' [ 29]

[id, ~, J] = unique(c(:,1));
[id num2cell(accumarray(J, [c{:,2}]', [], @mean))]

ans =

'3BAB38287GAAF' [ 32]
'3BAB38287PAPU' [233]
'3BAB38287POLA' [431]

% Bruno

Point your RSS reader here for a feed of the latest messages in this topic.

[Privacy Policy] [Terms of Use]

© Drexel University 1994-2015. All Rights Reserved.
The Math Forum is a research and educational enterprise of the Drexel University School of Education.