Apply condition to specific column and extract data from that row
11 次查看(过去 30 天)
显示 更早的评论
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)
0 个评论
回答(1 个)
Angelo Yeo
2022-10-4
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,:)
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Resizing and Reshaping Matrices 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!