How to sort Data from an Excel File...

27 views (last 30 days)
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 Comments
Walter Roberson
Walter Roberson on 21 Nov 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 on 21 Nov 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

Sign in to comment.

Accepted Answer

Siriniharika Katukam
Siriniharika Katukam on 25 Nov 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 Comments
Lauren Kilgore
Lauren Kilgore on 25 Nov 2019
Thank you! I will look into this.
Walter Roberson
Walter Roberson on 25 Nov 2019
If you switch from xlsread() to readtable() then the first variable in the table will automatically be created as datetime() objects

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!