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 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
T4H14
am 24 Okt. 2017
Kommentiert: Peter Perkins
am 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 Kommentare
per isakson
am 24 Okt. 2017
Bearbeitet: per isakson
am 24 Okt. 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
am 16 Nov. 2017
T4H14, you probably want to use a categorial variable with categories named something like Non-Holiday, US-Holiday, and NERC-Holiday.
Akzeptierte Antwort
Walter Roberson
am 24 Okt. 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 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Holidays / Seasons finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!