How do i Filter out table columns headers based on given query words?

5 visualizaciones (últimos 30 días)
Dear Experiences
i have a table that look like the following:
Table:
Name RC BV CC RQ CY ..... TY
A1 1 0 1 0 1 0
A2 1 0 0 0 0 0
A3 0 1 1 0 1 0
A4 0 0 0 0 0 1
then for the given query word such as ( A1 ) then the result perhaps store in cell array like:
Result ={ RC , CC , CY ,...} where the values of A1 in the corresponding columns header are 1.
i would thanks any one can give me help.

Respuesta aceptada

Walter Roberson
Walter Roberson el 19 de Ag. de 2017
YourTable.Properties.VariableNames( logical(YourTable{1,:}) )
  1 comentario
Peter Perkins
Peter Perkins el 23 de Ag. de 2017
You could also make Name the row names, i which case Walter's answer looks like
YourTable.Properties.VariableNames( logical(YourTable{'A1',:}) )

Iniciar sesión para comentar.

Más respuestas (1)

KL
KL el 19 de Ag. de 2017
x = rand(3,3);
rowX = {'A1','A2','A3'};
xT = array2table(x,'RowNames',rowX)
xA1 = table2cell(xT({'A1'},:))
  2 comentarios
ahmed obaid
ahmed obaid el 19 de Ag. de 2017
thanks, your code its retrieve the values of first row A1, while my request perhaps retrieve the columns headers, so according to my example in the above table the result of A1 ={RC, CC, CY} because the values of A1 row are 1 in these columns headers.
KL
KL el 19 de Ag. de 2017
Oh yes. Check out Walter's answer.

Iniciar sesión para comentar.

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by