How can i retrieve column based on cell values?

조회 수: 1 (최근 30일)

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

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

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기

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

Translated by