Add row to an empty array if a condition is fulfilled
5 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Mariel Cristo
am 21 Apr. 2021
Bearbeitet: Mariel Cristo
am 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 Kommentare
Akzeptierte Antwort
James Tursa
am 21 Apr. 2021
Bearbeitet: James Tursa
am 21 Apr. 2021
No need for an explicit loop. Just use logical indexing:
result = m(strcmp(m(:,3),'A'),:);
0 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Matrix Indexing finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!