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 2017-10-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/363002-how-do-i-add-a-new-column-to-a-table-which-is-a-binary-or-intiger-depending-upon-if-the-date-is-a-ho

评论： 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更早的评论隐藏 4更早的评论

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 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 2017-10-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/363002-how-do-i-add-a-new-column-to-a-table-which-is-a-binary-or-intiger-depending-upon-if-the-date-is-a-ho#answer_287521

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?