Removing weekends and holidays from a TimeTable
10 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
How can one remove weekends and holidays entries from a TimeTable?
Thanks!
0 Commenti
Risposta accettata
Peter Perkins
il 15 Mar 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 Commenti
Wolfgang McCormack
il 19 Gen 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?
Più risposte (1)
Sonima
il 20 Apr 2019
Modificato: Sonima
il 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 Commento
Walter Roberson
il 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
Vedere anche
Categorie
Scopri di più su Calendar in Help Center e File Exchange
Prodotti
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!