Organize Excel date and time data
1 次查看(过去 30 天)
显示 更早的评论
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 个)
Guillaume
2019-11-22
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);
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Shifting and Sorting Matrices 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!