Index table with cell array
Mostrar comentarios más antiguos
I have a table in which one of the columns is a cell array of text data, and a cell array C that contains a subset of this text. Is there a way to extract from the table only the rows with the text in C?
Respuesta aceptada
Más respuestas (1)
Matt J
el 19 de Nov. de 2021
0 votos
Yes, you can use ismember(...,'rows') to find the indices of the rows.
3 comentarios
Kim Maria Damiani
el 19 de Nov. de 2021
@Kim Maria Damiani: do not use the whole table, just the variable that you want to compare. Also the order needs to be swapped around in order for it to work correctly:
idx = ismember(T.NameOfVariable, C)
out = T(idx,:)
Kim Maria Damiani
el 19 de Nov. de 2021
Categorías
Más información sobre Data Type Identification en Centro de ayuda y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!