Search code examples
pythonpandasdate-range

pandas date_range does not exclude holidays

I have been trying to exclude a set of dates from my pandas bdate_range result but for some reason they keep on appearing.

I was following the notes within here https://pandas.pydata.org/docs/reference/api/pandas.bdate_range.html, ie apply bdate_range and also freq='C' . I thought that my exclude from list has been set up incorrectly, but am not seeing any errors thrown out when the script is run.

Sample code is below. Is anyone able to see what I have done wrong? would prefer the bdate_range to work instead of placing in some sort of workaround

import pandas as pd  
import datetime

exclude = [pd.datetime(2020, 1, 7), pd.datetime(2020, 1, 27)]

pd.bdate_range('2020/1/1','2020/1/31',freq='C',  holidays=exclude, )

Result still includes the 7th and the 27th that I am attempting to exclude out

DatetimeIndex(['2020-01-01', '2020-01-02', '2020-01-03', '2020-01-06',
               '2020-01-07', '2020-01-08', '2020-01-09', '2020-01-10',
               '2020-01-13', '2020-01-14', '2020-01-15', '2020-01-16',
               '2020-01-17', '2020-01-20', '2020-01-21', '2020-01-22',
               '2020-01-23', '2020-01-24', '2020-01-27', '2020-01-28',
               '2020-01-29', '2020-01-30', '2020-01-31'],
              dtype='datetime64[ns]', freq='C')

screenshot of result

Have also tried using from datetime as suggested, but same result

using from datetime

Solution

  • Instead of
    import datetime
    do
    from datetime import datetime
    and instead of
    exclude = [pd.datetime(2020, 1, 7), pd.datetime(2020, 1, 27)]
    do
    exclude = [datetime(2020, 1, 7), datetime(2020, 1, 27)]