how do i select data from a column based on another column?

Basically, I have two data columns: one with depth, the following column with its corresponding temperature. However the depth is in a random order with no sort of set intervals either.
How would I for example find all values for Temperature (column 2) for when depth (column 1) equals Zero?
Thanks, Pietro

 Accepted Answer

a=[1 2;3 4;5 0;5 1;1 0;7 8;4 0]
out=a(a(:,2)==0,:)

2 Comments

thanks a lot! is there any way to loop it so that I can get separate columns for each depth?
When I attempt to loop it now, it remains within the same matrix. so basically im getting everything put in order of increasing depth.
You don't need a loop
c1=out(:,1)
c2=out(:,2)

Sign in to comment.

More Answers (0)

Categories

Find more on Loops and Conditional Statements in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!