How do I add a new column to a table which is a binary or intiger depending upon if the Date is a holiday or not?
4 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
T4H14
le 24 Oct 2017
Commenté : Peter Perkins
le 16 Nov 2017
I want to create a new variable called Holiday which is equal to an integer of my choosing depending upon if the Date in the same row of the table is a holiday or not. Some holidays mean more than others for this model so I want to return an integer of differing values for different holidays if possible. 4th of july would be a 3 (for example) and Veteran's Day would be a 1.
6 commentaires
per isakson
le 24 Oct 2017
Modifié(e) : per isakson
le 24 Oct 2017
- AFAIK: info on holidays is not available in Matlab, except for the financial toolbox where the number of trading days is important.
- I once made a function for Sweden. I found the data I needed on a governmental web-page.
- See the thread NERC holiday calendar
Peter Perkins
le 16 Nov 2017
T4H14, you probably want to use a categorial variable with categories named something like Non-Holiday, US-Holiday, and NERC-Holiday.
Réponse acceptée
Walter Roberson
le 24 Oct 2017
In a table data structure, the only way to have a column which could be either logical or integer is to use a cell array so that each entry in the column can contain a different data type.
However, your description of using either 0, 1, or 2, would be integers, and you do not need anything special for integers. Adding two logicals gives an integer (a double).
Question: is it possible for something to be a NERC holiday but not a US Bank Holiday?
2 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Holidays / Seasons dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!