find multiple words in a cell

2013 1 9
4 个回答
回答已采纳
20 次查看（30 天）

0 个投票

Hi, is there a way to compare and return a number for the matching words in two unequal cells?
A={'a','a','a','b','b','d'} B={'a','b','c','d','e','f','g','h'}
return C=3,2,0,1,0,0,0,0
Thank you

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

 采纳的回答

Ryan Livingston
Ryan Livingston 2013-1-9

1 个投票

A one-liner:
cellfun(@(x)sum(ismember(A,x)), B)

更多回答（3 个）

Matt J
Matt J 2013-1-9

0 个投票

If the "words" will really always be single letters, you could do it looplessly with
>> histc([A{:}], [B{:}])
ans =
3 2 0 1 0 0 0 0

6 个评论
显示 4更早的评论 隐藏 4更早的评论

Vincent I
Vincent I 2013-1-9
ok I missed something on my initial comment. what if
A={'a_1','ab','a','b','b','d'}
B={'a','b','c','d','e','f','g','h'}
return C=3,2,0,1,0,0,0,0
Matt J
Matt J 2013-1-9
Post this as a new question. When you do, explain why 'b' gets only a count of 2 even though it occurs 3 times in A. Also explain what would happen if a letter occurs twice in the same string, e.g.
A={'a_1ab','bb'}; B={'a','b'};
Vincent I
Vincent I 2013-1-9
编辑：Vincent I 2013-1-9
ohh I see... b should get a count of two...
A={'a_1','a_2','a','b','b','d'}
B={'a','b','c','d','e','f','g','h'}
return C=3,2,0,1,0,0,0,0
And, although this is a new question, I feel that it is not far away for the initial question which I dont see why should require a new post
thank you
Daniel Shub
Daniel Shub 2013-1-9
@Vincent So you are looking for non-exact matches? I don't see your accepted answer works for that.
Matt J
Matt J 2013-1-9
编辑：Matt J 2013-1-9
And, although this is a new question, I feel that it is not far away for the initial question which I dont see why should require a new post
It doesn't require it, but if you post it as a new question, people have the opportunity to gain points from answering you (now that you've already accepted Ryan's answer), and so will be more incentivized to do so.
Jan
Jan 2013-1-10
编辑：Jan 2013-1-10
The decision is easy:
New question, new thread.
And:
Additional information to an existing question is added by editing the question and marking the changes by "[EDITED]". Then this is clarification and *not* a new question.
Hiding important information in deeply nested comments to already accepted questions is a bad idea.

请先登录，再进行评论。

Daniel Shub
Daniel Shub 2013-1-9

0 个投票

I am sure that this is over thinking the solution and I doubt that using regexp is optimal, but I was curious how bad it would be.
x = regexp(A, cell2mat(cellfun(@(x)['(?<', x, '>', x, ')|'], B, 'UniformOutput', false)), 'names');
cellfun(@(x)length([y.(x)]), fieldnames([x{:}]))'
I is there a better way to do this with regexp?

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Vincent I
Vincent I 2013-1-9
编辑：Vincent I 2013-1-9
Solved my problem by doing the folowing:
A=TF(:,1).';
A=regexprep(A, ' ','');
A=regexprep(A, '_(\w*)','');
B={'aa','bb2c','bb25c','xy3c','m56c','etc56c'};
C=cellfun(@(x)sum(strcmp(A, x)), B);
Thank you

请先登录，再进行评论。

Jan
Jan 2013-1-10

0 个投票

[EDITED, Jan, moved from comments to the accepted question]
ISMEMBER sorts the inputs and performs a binary search. This can be much faster and much slower than an unsorted comparison by:
cellfun(@(x)sum(strcmp(A, x)), B)
I claim without a proof, that a loop is faster:
R = zeros(1, numel(B));
for iB = 1:numel(B)
R(iB) = sum(strcmp(A, B{iB}));
end
[EDITED 2] And if you want to compare the leading character(s) only:
...
R(iB) = sum(strncmp(A, B{iB}, length(B{iB}));
...

类别

在 帮助中心 和 File Exchange 中查找有关 Data Type Identification 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by