Using loops and strcmp. Have 1 master char array, need to find matches of each entry in 2 other arrays.

Question

Alexander 2014-3-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/123548-using-loops-and-strcmp-have-1-master-char-array-need-to-find-matches-of-each-entry-in-2-other-arra

编辑： dpb 2014-3-31

采纳的回答： dpb

在 MATLAB Online 中打开

I have 3 variables, each are list-like char arrays.

Var1 is a list of unique 3-letter strings, in alphabetical order.

Var2 and Var 3 are lists where the entries are a random combination of the unique strings in Var1. The unique strings can appear multiple times or not at all. Var 2 and 3 are of equal length, but not Var1.

What I have so far:

num_of_matches1=0; 
num_of_matches2=0; 
for k=1:length(charstring1) 
for i=1:length(charstring2) 
MatchChecker=strcmp(charstring1(k), 
charstring2(i)); 
if MatchChecker==1  
num_of_matches1=num_of_matches1+1; 
end 
end 
for j=1:length(charstring3) 
MatchChecker=strcmp(charstring1(k), 
charstring3(j)); 
if MatchChecker==1 
num_of_matches2=num_of_matches2+1; 
end 
end

Eventually, I need to print results in a table like this:

Charstring Name            Matches in Var2             Matches in Var3 
     ABC                         5                             8
     BAS                         8                             7
     etc.

2 个评论
显示无隐藏无

dpb 2014-3-28

How about a mini-dataset to play with that illustrates characteristic data?

Alexander 2014-3-28

在 MATLAB Online 中打开

Below are variables.

Var1=[ABC; XYZ; ZZZ]
Var2=[XYZ; ZZZ; ZZZ; ZZZ; ABC; ABC; ZZZ]
Var3=[ABC; ZZZ; ABC; ABC; XYZ; XYZ;ABC]

Need output

Name        Match in Var2        Match in Var3
ABC              2                     4
XYZ              1                     2
ZZZ              4                     1

请先登录，再进行评论。

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

Answer 1

dpb 2014-3-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/123548-using-loops-and-strcmp-have-1-master-char-array-need-to-find-matches-of-each-entry-in-2-other-arra#answer_131131

编辑：dpb 2014-3-29

在 MATLAB Online 中打开

Oh, that's pretty simple, then...

>> for i=1:size(Var1,1)
     disp([sum(ismember(Var2,Var1(i,:),'rows')) ...
           sum(ismember(Var3,Var1(i,:),'rows'))])
   end
   2     4
   1     2
   4     1
>>

You can go further and replace the loop construct if desired...

ADDENDUM:

Altho in that case entails converting VarN to cellstring arrays owing to addressing a character string by the second address isn't supported in arrayfun syntax.

>> (cellfun(@(x) sum(ismember(cellstr(Var2),x)),cellstr(Var1)))
ans =
   2
   1
   4
>>

2 个评论
显示无隐藏无

Alexander 2014-3-29

One more thing; I need to save the results of the for loop as an array. Also in the array, the third column is the sum of col 1 and 2. What you gave gives me displays the results, but I need them as an array that I can call later on.

dpb 2014-3-30

编辑：dpb 2014-3-30

A) What does the result of the note in the ADDENDUM return? :)

B) You can't write a sum of two terms? Gotsa' leave something for the "exercise for the student" :)

C) If you still want to stay with the looping solution, preallocate a results array and populate it with the answers as you iterate thru the Var1 variable.

请先登录，再进行评论。

Answer 2

dpb 2014-3-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/123548-using-loops-and-strcmp-have-1-master-char-array-need-to-find-matches-of-each-entry-in-2-other-arra#answer_131397

编辑：dpb 2014-3-31

在 MATLAB Online 中打开

>> mtch=[cellfun(@(x) sum(ismember(C2,x)),C1) ...
         cellfun(@(x) sum(ismember(C3,x)),C1)];
>> mtch=[mtch sum(mtch,2)]
mtch =
   2     4     6
   1     2     3
   4     1     5
>>