Finding most frequent element in a cell array without using unique function?

Question

Kratos 2015-3-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/181771-finding-most-frequent-element-in-a-cell-array-without-using-unique-function

回答： Geoff Hayes 2015-3-7

Hello I am stuck trying to figure small block of code. I have cell array of repeating strings and numbers(class double) corresponding to the strings.

 Name     Score
 'John'    90
 'Mat'     99
 'John'    98
 'Tonny'   88
 'Carl'    99
 'Rem'     88
 'Tonny'   99

How do I count the number of times the same name appears and the total score they got. For instance the total score for 'John' would be 188. I know you can use unique function to do it, but is there other way to do it beside using unique. It would be great if you guys could help me out. Thanks

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Geoff Hayes 2015-3-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/181771-finding-most-frequent-element-in-a-cell-array-without-using-unique-function#answer_170458

在 MATLAB Online 中打开

Kratos - if you are unable to use unique (it is unclear why) then if the above data is in a cell array as

 data = { 'John'    90
          'Mat'     99
          'John'    98
          'Tonny'   88
          'Carl'    99
          'Rem'     88
          'Tonny'   99};

sort the data in the first column using sortrows. Then iterate over each row and compare (using strcmp) the name in that row with the name in the previous row. If identical, then sum the score with that from the previous row and continue in this fashion until you encounter a row with a different name. At that point, all elements prior to this one have the same name and so you can write out the total score for that individual. Now start with the new name and continue with the next row. Are the two names identical? If so, add the two scores and continue. If not, then write out the score for the previous name and continue.