# How to split a matrix by a column by whether values are greater or less than a number

9 views (last 30 days)
Harry Stanton on 20 Jan 2016
Answered: Azzi Abdelmalek on 20 Jan 2016
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

Ilham Hardy on 20 Jan 2016
A = [5;3;6;1;7;8;2;3;4;8;6;5];
B = [45;25;36;87;45;14;2;31;59;6;47;2];
C = [4;5;8;6;11;14;9;5;1;19;3;10];
matt = [A,B,C];
matt1 = matt(find(matt(:,3)<7),:);
matt2 = matt(find(matt(:,3)>7),:);

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 Matrix Indexing 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!

Translated by