How to seperate weekdays and weekends from an hourly data?

Question

Mahavir Nakum 2018-3-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/388954-how-to-seperate-weekdays-and-weekends-from-an-hourly-data

评论： Steph 2019-2-6

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Von Duesenberg 2018-3-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/388954-how-to-seperate-weekdays-and-weekends-from-an-hourly-data#answer_310464

在 MATLAB Online 中打开

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,:);