MATLAB Answers

How can i query last column based on another values column

1 view (last 30 days)
Mochammad Fariz
Mochammad Fariz on 18 Feb 2020
Commented: KSSV on 18 Feb 2020
i have excel database consisting percentage values from column 1-27..my question is how can i query last column (file path of an image / column 28) based on threshold..for your information my threshold is = 1.6155 from column 1-27

  2 Comments

Mochammad Fariz
Mochammad Fariz on 18 Feb 2020
i try some images to know threshold how much minimum value percentage of color to display in image..for example the image contains red,yellow,blue,green, and brown ..
red = 14.08888
yellow = 1.5554
blue = 30.8775
green = 0.8755
brown = 0.2377
then in GUI matlab will show " this image contains blue,red "

Sign in to comment.

Answers (1)

KSSV
KSSV on 18 Feb 2020
You can use inequalitites ==, >, <, >=, <=. Read about them.
Read the excel data into MATLAB using xlsread or readtable.
If A is your column, and val is your value 1.6155.
% get values less then val
idx = A<val ; % this gives logical indices which are less then val
A(A<val) % this gives values which are less then val

  7 Comments

Show 4 older comments
KSSV
KSSV on 18 Feb 2020
Get the indices from num..and use those indices to querry the string column....
Mochammad Fariz
Mochammad Fariz on 18 Feb 2020
could you give me some codes to query last column (string path name) based on (column 1-27 percentage name)like i describe in my picture database excel above??
KSSV
KSSV on 18 Feb 2020
get the last column by using
iwant = raw(:,end) ;

Sign in to comment.

Sign in to answer this question.


Translated by