Add row to an empty array if a condition is fulfilled
5 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Mariel Cristo
il 21 Apr 2021
Modificato: Mariel Cristo
il 22 Apr 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 Commenti
Risposta accettata
James Tursa
il 21 Apr 2021
Modificato: James Tursa
il 21 Apr 2021
No need for an explicit loop. Just use logical indexing:
result = m(strcmp(m(:,3),'A'),:);
0 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Matrix Indexing in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!