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

1 Ansicht (letzte 30 Tage)
Loran
Loran am 14 Sep. 2014
Kommentiert: Image Analyst am 14 Sep. 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

Antworten (1)

Image Analyst
Image Analyst am 14 Sep. 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 Kommentare
Loran
Loran am 14 Sep. 2014
Great, thanks so much. Appreciated! :) Loran
Image Analyst
Image Analyst am 14 Sep. 2014
You're welcome. You can also thank by officially "Accepting" and voting for the answer.

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu Language Fundamentals finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by