Organize Excel date and time data
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (1)
Guillaume
le 22 Nov 2019
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 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!