Effacer les filtres
Effacer les filtres

Apply condition to specific column and extract data from that row

9 vues (au cours des 30 derniers jours)
Kanbodin
Kanbodin le 4 Oct 2022
Hi, I'm working with a matrix with 3 column and n amount of rows
I want to apply a condition to the 1st and 2nd column, then extract the data from the 3rd column which the condition is matched.
for example, I have A =
1 2 3
2 6 6
1 8 5
3 2 7
8 4 3
6 8 1
I want to extract the data from 3rd cloumn in the row where the condition are,
  • value of the 1st column in less that 5
  • value of the 2nd column is more that 5,
Therefore, I will have data from 2nd and 3rd row (6 and 5)

Réponses (1)

Angelo Yeo
Angelo Yeo le 4 Oct 2022
A = [1 2 3
2 6 6
1 8 5
3 2 7
8 4 3
6 8 1];
idx_row = (A(:,1) < 5) & (A(:,2) > 5);
A(idx_row,:)

Catégories

En savoir plus sur Matrix Indexing dans Help Center et File Exchange

Produits


Version

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by