Removing weekends and holidays from a TimeTable

10 次查看（过去 30 天）

显示更早的评论

Andy 2018-3-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/388366-removing-weekends-and-holidays-from-a-timetable

评论： Peter Perkins 2021-2-18

采纳的回答： Peter Perkins

How can one remove weekends and holidays entries from a TimeTable?

Thanks!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Peter Perkins 2018-3-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/388366-removing-weekends-and-holidays-from-a-timetable#answer_310093

在 MATLAB Online 中打开

Weekends is simple:

TT = TT(~isweekend(TT.Time),:) % assumes the default name, Time, for the row times

Holidays are another story, but if you have a list of the ones you care about, use ismember on TT.Time. You may need to use dateshift to "round" to whole days, depending on what your data look like. Perhaps something like

ismember(dateshift(TT.Time,'start','day'),listOfHolidays)

Also, if you have access to the Financial Toolbox, you can use that to generate a list of dates to remove.

4 个评论
显示 2更早的评论隐藏 2更早的评论

Wolfgang McCormack 2021-1-19

@Peter Perkins hi, how can i get the reverse of what you just did with weekends, How can I get rid of weekdays and keep the wekend only?

Peter Perkins 2021-2-18

Leave out the ~.

请先登录，再进行评论。

更多回答（1 个）

Sonima 2019-4-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/388366-removing-weekends-and-holidays-from-a-timetable#answer_371467

编辑：Sonima 2019-4-20

在 MATLAB Online 中打开

Hi!

This works and remove the weekends from a TimeTable, but still gaps showed up on the plot!

TT = TT(~isweekend(TT.Time),:);

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Walter Roberson 2019-4-24

Yes, this is to be expected. plot() positions elements by relative numeric position, and the relative numeric position of Monday to Monday is 7 days not 5 days.

You could look in the File Exchange for the various "break plot" routines. Or... you could use a time axes that was some kind of relative business days apart measure and adjust the tick labels to the associated dates.

Either way, getting zoom and pan and data tips (datacursor) right is a nuisance

请先登录，再进行评论。

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