How to seperate weekdays and weekends from an hourly data?
5 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
I have a data in excel which has data in yyyy-mm-dd hr:min:sec Am/PM format and I want to separate this data to weekdays and weekends without doing any average of it. How do I do it?
Thank Mahavir
0 Kommentare
Antworten (1)
Von Duesenberg
am 17 Mär. 2018
Here's what I do (byHourTable is a timetable object with a column called Timestamps):
%get day names
[~, dayNames] = weekday(byHourTable.Timestamps, 'short');
%find indices of week days
indWorkDay = ismember(dayNames, {'Mon', 'Tue', 'Wed', 'Thu', 'Frid'});
%extract data for week days only
aggrDay = byHourTable(indWorkDay,:);
1 Kommentar
Siehe auch
Kategorien
Mehr zu Tables finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!