How can i retrieve column based on cell values?

1 visualizzazione (ultimi 30 giorni)
Mochammad Fariz
Mochammad Fariz il 14 Feb 2020
Commentato: Mochammad Fariz il 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

Accedi per rispondere a questa domanda.

Risposta accettata

Jacob Wood
Jacob Wood il 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}};

Più risposte (0)

Categorie

Scopri di più su Spreadsheets in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by