Removing weekends and holidays from a TimeTable
12 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Andy
am 14 Mär. 2018
Kommentiert: Peter Perkins
am 18 Feb. 2021
How can one remove weekends and holidays entries from a TimeTable?
Thanks!
0 Kommentare
Akzeptierte Antwort
Peter Perkins
am 15 Mär. 2018
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 Kommentare
Wolfgang McCormack
am 19 Jan. 2021
@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?
Weitere Antworten (1)
Sonima
am 20 Apr. 2019
Bearbeitet: Sonima
am 20 Apr. 2019
Hi!
This works and remove the weekends from a TimeTable, but still gaps showed up on the plot!
TT = TT(~isweekend(TT.Time),:);
1 Kommentar
Walter Roberson
am 24 Apr. 2019
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
Siehe auch
Kategorien
Mehr zu Calendar finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!