How can i retrieve column based on cell values?

Question

Mochammad Fariz 2020-2-14

评论： Mochammad Fariz 2020-2-18

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

Answer 1

Jacob Wood 2020-2-14

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}};

Mochammad Fariz 2020-2-14

thank u mate

Mochammad Fariz 2020-2-18

could you help me Jacob?? i don't have idea query column based on column..this is my link of question