Printing specific rows based on column from excel

3 visualizaciones (últimos 30 días)
Sai Gautam Mandapati
Sai Gautam Mandapati el 11 de Abr. de 2022
Comentada: Sai Gautam Mandapati el 12 de Abr. de 2022
Good Day,
I have an excel sheet with 7296 rows and 9 columns. So, I want to get certain rows only based on the column value. For example:
Time Node FaceID FaceDescr Type Packets Kilobytes PacketsRaw KiloBytesRaw
Like the above snippet I have certain rows with the FaceDesc 'ALL' as one of the columns. So, I want my code to print only those rows. I have some unecessary rows that I don't want the code to print like the below screenshot shows. Can anyone please nudge towards the right direction of getting what I need? I'm new to MatLab. Thank you.

Iniciar sesión para responder a esta pregunta.

Respuesta aceptada

KSSV
KSSV el 11 de Abr. de 2022
T = readtable(myfile) ;
idx = matches(T.FaceDescr,'all') ;
T(idx,:)
  4 comentarios
Mostrar 2 comentarios más antiguos
KSSV
KSSV el 12 de Abr. de 2022
Get indices of each column and use logical and.

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