comparing two columns of a table in MATLAB

Question

Annick 2020-3-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/513366-comparing-two-columns-of-a-table-in-matlab

评论： Annick 2020-3-27

Hello!

I want to compare the second column with the 3rd column to find out if there is any row having the same values in both columns.

Let's say, for example, 1st ,3rd and 4th rows have the same values in both the two columns. I would like to add another column to the table which shows me if the rows are compared with eachother.

Currently I have wrote this loop, but it writes 0 eventhough the columns are the same

i=1:height(Table1);
    if(Table1.Interval1 == Table1.ActivityCode1)
        Comparison(i)= 1;
    else
        Comparison(i)= 0;
    end
   Comparison = (Comparison)';

Could you please help me?

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

请先登录，再进行评论。

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

Answer 1

Geoff Hayes 2020-3-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/513366-comparing-two-columns-of-a-table-in-matlab#answer_422355

编辑：Geoff Hayes 2020-3-27

在 MATLAB Online 中打开

Annick - how about you remove the loop and just do

Comparison = Table1.Interval1 == Table1.ActivityCode1;

Wouldn't Comparison be an array of ones and zeros where a one indicates that the two elements (in whatever row) are equal, and a zero indicating that the two elements aren't zero?