How can I find a data (number) within variable based on a condition…!

1 visualización (últimos 30 días)
Loran
Loran el 14 de Sept. de 2014
Comentada: Image Analyst el 14 de Sept. de 2014
Hello,
I am new to Matlab with very little experience!
I have a variable set with 5 columns, and I am trying to get a data from one column based on the condition of other column..
For example, I like to get the corresponding value in column 5 based on column 3.
while i = 50 in column 3 find the value of 22 from column 5? By changing i, get the corresponding number from column 5?
1400 1 1 3 11
1500 2 50 5 22
1600 3 100 7 33
1700 4 200 9 44
…..
Thanks so much!
Regards’
Loran

Respuestas (1)

Image Analyst
Image Analyst el 14 de Sept. de 2014
Try this:
m=[...
1400 1 1 3 11;
1500 2 50 5 22;
1600 3 100 7 33;
1700 4 200 9 44]
col3equals50 = m(:,3)==50 % Logical vector of where column 3 value = 50
extractedCol5Numbers = m(col3equals50, 5)
In the command window:
m =
1400 1 1 3 11
1500 2 50 5 22
1600 3 100 7 33
1700 4 200 9 44
col3equals50 =
0
1
0
0
extractedCol5Numbers =
22
  2 comentarios
Loran
Loran el 14 de Sept. de 2014
Great, thanks so much. Appreciated! :) Loran
Image Analyst
Image Analyst el 14 de Sept. de 2014
You're welcome. You can also thank by officially "Accepting" and voting for the answer.

Iniciar sesión para comentar.

Categorías

Más información sobre Language Fundamentals en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by