How can i query last column based on another values column

2 次查看（过去 30 天）
Mochammad Fariz
Mochammad Fariz 2020-2-18
评论： KSSV 2020-2-18
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 个评论
Mochammad Fariz
Mochammad Fariz 2020-2-18
编辑：Mochammad Fariz 2020-2-18
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 "

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

KSSV
KSSV 2020-2-18
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 个评论
显示 5更早的评论
Mochammad Fariz
Mochammad Fariz 2020-2-18
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??

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by