How can i query last column based on another values column
1 回表示 (過去 30 日間)
古いコメントを表示
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 件のコメント
回答 (1 件)
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 件のコメント
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!