# how to extract data with some condition

134 views (last 30 days)
Samaneh Arzpeima on 30 Nov 2018
Commented: Samaneh Arzpeima on 30 Nov 2018
Hello everyone
I have a 9 colomns of data,say x1 to x9, each colomn has 150 rows
I need to extract all the data when x2==0 and x1=0.5, and make a new dataset of 9 colomns
Please teach me how to do this
I will appreciate you help
madhan ravi on 30 Nov 2018
just give a numerical example still not clear

Mark Sherstan on 30 Nov 2018
Try the code below. You will have to change it to your data but you should get the idea.
% Generate a random matrix of intergers between 1 and 3
x = randi(3,[250 9]);
% Find where there are 1's in column one and 3's in column two for each row
row = find( x(:,1)==2 & x(:,2)==3 );
% Build a new matrix A that satisfies the condition of 1's and 3's
A = x(row,:)
Samaneh Arzpeima on 30 Nov 2018
thank you very much

R2018b

### Community Treasure Hunt

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

Start Hunting!