pandas date_range does not exclude holidays-CodePudding

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

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

CodePudding user response：

Are you sure you're executing the same thing you're sharing with us here? I just ran your code and it seems to exclude the dates you mention:

DatetimeIndex(['2020-01-01', '2020-01-02', '2020-01-03', '2020-01-06',
               '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-28', '2020-01-29', '2020-01-30',
               '2020-01-31'],
              dtype='datetime64[ns]', freq='C')

In case you get the deprecation warning, don't use pd.datetime but rather import it from its own library, using from datetime import datetime.

CodePudding user response：

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)]