How to sort Data from an Excel File...

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'); 

[Walter Roberson]

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]

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

Answer 1

[Siriniharika Katukam]

Hi

You may find a way to sort date and time from this link below:

https://www.mathworks.com/matlabcentral/answers/350784-sorting-cell-array-by-date

May be you need to change the format in "datenum"

[Lauren Kilgore]

Thank you! I will look into this.

[Walter Roberson]

If you switch from xlsread() to readtable() then the first variable in the table will automatically be created as datetime() objects