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

 Respuesta aceptada

Azzi Abdelmalek
Azzi Abdelmalek el 11 de Mayo de 2016
Editada: Azzi Abdelmalek el 11 de Mayo de 2016
a=[1 2;3 4;5 0;5 1;1 0;7 8;4 0]
out=a(a(:,2)==0,:)

2 comentarios

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)

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Loops and Conditional Statements en Centro de ayuda y File Exchange.

Etiquetas

Preguntada:

el 11 de Mayo de 2016

Comentada:

el 11 de Mayo de 2016

Community Treasure Hunt

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

Start Hunting!

Translated by