How can i retrieve column based on cell values?

2 Ansichten (letzte 30 Tage)
Mochammad Fariz
Mochammad Fariz am 14 Feb. 2020
Kommentiert: Mochammad Fariz am 18 Feb. 2020
I just stored my data from matlab to excel file using xlswrite , looks like this..but i have no idea to query column name based on cell values..
for example if my threshold is = 1.6155 then it will retrieve column name such as = "Merah Ma , Kuning, Hijau"
return the column name values where cell values greater than 1.6155

Melden Sie sich an, um diese Frage zu beantworten.

Akzeptierte Antwort

Jacob Wood
Jacob Wood am 14 Feb. 2020
You can accomplish this with logical indexing. See below for an example:
d = {'Putih','Abu-abu','Hitam'; 0.014149,0.04175,0.081601};
thresh = 0.02;
idx = [d{2,:}] > thresh;
col_names = {d{1,idx}};

Weitere Antworten (0)

Kategorien

Mehr zu Spreadsheets finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by