Add row to an empty array if a condition is fulfilled
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Mariel Cristo
el 21 de Abr. de 2021
Editada: Mariel Cristo
el 22 de Abr. de 2021
Hi everyone,
I have a 5 x 3 array and I have to make a code that checks row by row if the third column fulfills a condition. (In this case, the third column should be equal to the letter "A").
When there's an "A" in the third column, I have to take all that row and place it in a new array and this new array should have all the rows that fulfill the condition.
Edit:
And if I were to do it with a database that I have on Excel, how do I do it?
The column that has the condition that I need is the number 74, that's called "Usar". I tried it with the logical indexing but it showed me nothing.
0 comentarios
Respuesta aceptada
James Tursa
el 21 de Abr. de 2021
Editada: James Tursa
el 21 de Abr. de 2021
No need for an explicit loop. Just use logical indexing:
result = m(strcmp(m(:,3),'A'),:);
0 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Matrix Indexing 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!