Borrar filtros
Borrar filtros

How to sort Data from an Excel File...

24 visualizaciones (últimos 30 días)
Lauren Kilgore
Lauren Kilgore el 21 de Nov. de 2019
Comentada: Walter Roberson el 25 de Nov. de 2019
I am wanting to create a code that will read from an Excel file (I have attached an example below). I want the total number of students, check-in types to be sorted, and for the date and time to be sorted. I am very new to Matlab and this would help make my job much easier!
[~,~,rawData] = xlsread('matlabproject.xlsx');
  2 comentarios
Walter Roberson
Walter Roberson el 21 de Nov. de 2019
mask = ismember(rawData(:,3), {'Student Check-In (DB)', 'Student Check-Out (DB)'});
student_subset = rawData(mask,:);
Now you can start processing to find the unique column 2 (names) in student_subset and so on.
Lauren Kilgore
Lauren Kilgore el 21 de Nov. de 2019
Hi Walter,
Thank you so much! It works! Would you possibly know how to sort the date and time or direct me to some reasources to figure it out?
Thanks,
Lauren

Iniciar sesión para comentar.

Respuesta aceptada

Siriniharika Katukam
Siriniharika Katukam el 25 de Nov. de 2019
Hi
You may find a way to sort date and time from this link below:
May be you need to change the format in "datenum"
  2 comentarios
Lauren Kilgore
Lauren Kilgore el 25 de Nov. de 2019
Thank you! I will look into this.
Walter Roberson
Walter Roberson el 25 de Nov. de 2019
If you switch from xlsread() to readtable() then the first variable in the table will automatically be created as datetime() objects

Iniciar sesión para comentar.

Más respuestas (0)

Community Treasure Hunt

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

Start Hunting!

Translated by