most frequent word in cell array

3 次查看（过去 30 天）
Mahmoud Zeydabadinezhad
回答： Sarah Palfreyman 2018-4-30
Hi, I have a cell array "P" of size 2000 by 20. Each cell value is either "Yes" or "No". How can I make a new cell array "vote" of size 2000 by 1 that each cell contains the most frequent word of each row in P?

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

采纳的回答

Walter Roberson
Walter Roberson 2017-10-25
tf = ismember(lower(P), 'yes');
votes = sum(tf, 2);
  4 个评论
显示 2更早的评论
dpb
dpb 2017-10-26
编辑：dpb 2017-10-26
I was just throwing in the categorical variable into the mix in the end on top of your solution for the total by row using string matching thereby "mixing the two" of the cellstr variable to the categorical variables I had suggested totally (which did the sums via countcats) by then using the categorical to display the name in English of the winner...
Wasn't imply anything at all was wrong, just adding the final step and that primarily to "show off" categorical to the OP as worth looking at.
Walter Roberson
Walter Roberson 2017-10-26
Right, but I had overlooked that the question asked about the most common entry -- which can be found by testing the count against width/2

请先登录，再进行评论。

更多回答（2 个）

dpb
dpb 2017-10-25
编辑：dpb 2017-10-25
Good place to use categorical variables instead of the cellstr...
Example:
>> yn={'yes' 'no' 'Yes';'no' 'No', 'NO'}; % minimal dataset including capitaliztion differences
>> ync=categorical(lower(yn)); % convert to categorical and normalize spelling
>> cnts=countcats(ync,2) % count responses on 2nd dimension
cnts =
1 2
3 0
>> vote=cnts(:,2)>cnts(:,1); % see which is greater (Y>N --> True)
>> vote=categorical(vote,[true false],{'Yes','No'}) % convert to categorical to display
vote =
Yes
No
>> yn % original table to compare -- looks like right choice.
yn =
'yes' 'no' 'Yes'
'no' 'No' 'NO'
>>
NB: The above doesn't have the extra logic to check for tie--in case that is possible will need to test for == as well and add the third category of TIE as possible output.
ADDENDUM
If TIE is possible, look at computing difference between counts and then the SIGN function will generate the tri-state variable needed.
Sarah Palfreyman
Sarah Palfreyman 2018-4-30
Try tokenizing with Text Analytics Toolbox and you can easily get a histogram count.

类别

在 Help Center 和 File Exchange 中查找有关 Categorical Arrays 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by