How to seperate weekdays and weekends from an hourly data?
1 view (last 30 days)
Show older comments
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 Comments
Answers (1)
Von Duesenberg
on 17 Mar 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 Comment
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!