How to sort Data from an Excel File...
17 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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
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.
Respuesta aceptada
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
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
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!