comparing two columns of a table in MATLAB
33 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Annick
el 27 de Mzo. de 2020
Comentada: Annick
el 27 de Mzo. de 2020
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 comentarios
Respuesta aceptada
Geoff Hayes
el 27 de Mzo. de 2020
Editada: Geoff Hayes
el 27 de Mzo. de 2020
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?
Más respuestas (0)
Ver también
Categorías
Más información sobre Logical en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!