COMPARE CELLS VIA A LOOP

Question

Ivan Mich 2021-1-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/721879-compare-cells-via-a-loop

评论： Walter Roberson 2021-1-20

Hello,

I have a problem with a code. I have two columns with cell (200x1 cell) in a csv file. I would like to compare these two columns, and escpecially the first letter of them.

I wrote this code:

clc
clear
%comparison
filename1 = 'test.xlsx'; 
[d1,tex]= xlsread(filename1);
NAME1=tex(:,1); 
k1=strcat(NAME1{1}(1)) %first letter
NAME2=tex(:,3); 
k2=strcat(NAME2{1}(1)) %first letter
ndata=1:size(NAME1,1)

but I do not know how to continue it.

I think if statement would help. I mean:

for i
    if k1==k2 
        write 'aggree'
    else write 'disaggree'
    end
end

Could you please help me?

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2021-1-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/721879-compare-cells-via-a-loop#answer_601899

在 MATLAB Online 中打开

%comparison
filename1 = 'test.xlsx'; 
[d1,tex]= xlsread(filename1);
NAME1=tex(:,1); 
k1 = cellfun(@(C) C(1), NAME1);  %first letter
NAME2=tex(:,3); 
k2 = cellfun(@(C) C(1), NAME2);  %first letter
mask = k1 == k2;
choices = {'disagree', 'agree'};
results = choices(mask+1);