Organize Excel date and time data

Question

Lauren Kilgore 2019-11-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/492506-organize-excel-date-and-time-data

评论： Guillaume 2019-11-22

practice.xlsx

I am trying to sort this data by date and time. In the file attached, you can see that the time and date are in the same cell. I have tried sort without any luck. I am wondering if it is possible to display a graph for each date and then plotting the times for that date.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Lauren Kilgore 2019-11-22

编辑：Lauren Kilgore 2019-11-22

practice.xlsx

I attached an updated excel file. I would like to organize the data by the date/time and the reader. From there, I would like to plot a line graph to show the trend of students visiting the tutoring center by each room.

Guillaume 2019-11-22

I'm unclear on what would go on the X and Y axis of your line graph.

请先登录，再进行评论。

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

Answer 1

Guillaume 2019-11-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/492506-organize-excel-date-and-time-data#answer_402818

在 MATLAB Online 中打开

It's trivial to sort if you read the data in a table or a timetable:

data = readtable('Practice.xlsx', 'ReadVariableNames', false);
sorteddata = sortrows(data, 1);  %sort rows according to first column

or

data = readtimetable('Pracice.xlsx', 'ReadVariableNames', false);
sorteddata = sortrows(data, 'Time')  %sort rows according to time

However, for plotting per day you don't even need to sort the function, you can use groupsummary with a grouping by day to call your plotting function with the data of each day. With you demo excel file, it's unclear what you want to plot since the 2nd column is made of names. But it'd go something like this

%demo with timetable
data = readtimetable('Practice.xlsx', 'ReadVariableNames', false);
%for this demo adding a numerical column with random numbers for plotting. Now idea what you want to plot
data.Numbers = rand(height(data), 1)
%plotting
figure; hold('on')
gplot = groupsummary(data, 'Time', 'day', @plot, 'Numbers');
legend(gplot.day_Time);