comparing table values using isequal

110 visualizaciones (últimos 30 días)
Jakub Steiner
Jakub Steiner el 15 de Sept. de 2020
Comentada: Cris LaPierre el 15 de Sept. de 2020
Hi,
I have a table M. The second column contains either the letter 's' or letter 'f'.
I would like to put all the rows with the letter 'f' in the second column into a new table A with the following code
pocet_radku = height(M);
j=1;
for i=1:pocet_radku
TF = isequal ("M(i,2)",'f')
if TF == 1
A(j,:)= M(i,:);
j = j+1;
else
end
end
Unfortunatelly, the isequal function return only zeros. Any idea why? In there syntax error that I'm not aware of?
Testing in a command window:
>> isequal ("M(180,2)",'f')
ans =
logical
0
>> M(180,2)
ans =
table
Var2
_____
{'f'}
Thanks a lot for any answers

Respuesta aceptada

Cris LaPierre
Cris LaPierre el 15 de Sept. de 2020
Editada: Cris LaPierre el 15 de Sept. de 2020
This can be done much simpler. Try something like this.
A = M(M{:,2}=="f",:);
  2 comentarios
Jakub Steiner
Jakub Steiner el 15 de Sept. de 2020
Nice! Works as well and without my clumsy cycles.
Thanks a lot!
Cris LaPierre
Cris LaPierre el 15 de Sept. de 2020
This can be made even simpler by using the variable name:
A = M(M.Var2=="f",:);

Iniciar sesión para comentar.

Más respuestas (2)

Fangjun Jiang
Fangjun Jiang el 15 de Sept. de 2020
Editada: Fangjun Jiang el 15 de Sept. de 2020
try TF = isequal (M.Var2{i},'f')

BOB MATHEW SYJI
BOB MATHEW SYJI el 15 de Sept. de 2020
Instead of
TF = isequal ("M(i,2)",'f')
try,
TF = strcmp (M.2nd_variable,'f')

Categorías

Más información sobre Logical en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by