How to split a matrix by a column by whether values are greater or less than a number
Show older comments
I have a matrix:

I would like to split this into two new matrices which are dependent on whether the values in column C are greater than 7 or less than 7.
I have tried a loop:
for i=1:12
if matrix(i,3)>7
A=(matrix(i,:))
elseif matrix(i,3)<7
B=(matrix(i,:))
end
end
this did not give me two matrices.
Can anyone help? Many thanks
Accepted Answer
More Answers (1)
Azzi Abdelmalek
on 20 Jan 2016
A=randi(10,6,3)
idx=A(:,3)>7
A1=A(idx,:)
A2=A(~idx,:)
Categories
Find more on Creating and Concatenating Matrices in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!