How to sort Data from an Excel File...

18 次查看（过去 30 天）
Lauren Kilgore
Lauren Kilgore 2019-11-21
评论： Walter Roberson 2019-11-25
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 个评论
Walter Roberson
Walter Roberson 2019-11-21
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 2019-11-21
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

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

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"
  2 个评论
Walter Roberson
Walter Roberson 2019-11-25
If you switch from xlsread() to readtable() then the first variable in the table will automatically be created as datetime() objects

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by