How can i retrieve column based on cell values?

1 visualización (últimos 30 días)
Mochammad Fariz
Mochammad Fariz el 14 de Feb. de 2020
Comentada: Mochammad Fariz el 18 de Feb. de 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

Iniciar sesión para responder a esta pregunta.

Respuesta aceptada

Jacob Wood
Jacob Wood el 14 de Feb. de 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}};
  2 comentarios
Mochammad Fariz
Mochammad Fariz el 14 de Feb. de 2020
thank u mate
Mochammad Fariz
Mochammad Fariz el 18 de Feb. de 2020
could you help me Jacob?? i don't have idea query column based on column..this is my link of question
https://www.mathworks.com/matlabcentral/answers/506096-how-can-i-query-last-column-based-on-another-values-column

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Spreadsheets en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by