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?

2 次查看（过去 30 天）
T4H14
T4H14 2017-10-24
评论： Peter Perkins 2017-11-16
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 个评论
显示 4更早的评论
per isakson
per isakson 2017-10-24
编辑：per isakson 2017-10-24
  • 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
Peter Perkins 2017-11-16
T4H14, you probably want to use a categorial variable with categories named something like Non-Holiday, US-Holiday, and NERC-Holiday.

请先登录，再进行评论。

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

采纳的回答

Walter Roberson
Walter Roberson 2017-10-24
https://www.mathworks.com/help/finance/isbusday.html
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?

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Holidays / Seasons 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by