Python3 Count Number of Week Days Ignoring Holidays

Question

Testing one of my scripts it appears that Numpy busday_count includes Labor Day (September 2nd). Is there a way to disable the holidays?

print (np.busday_count('2019-08-31', '2019-09-02'))

Result = 0, but 9/2/2019 is clearly Labor Day and a Monday.

print (np.busday_count('2019-08-31', '2019-09-03'))

Result = 1, but it should be 2. As far as I know the formula excludes the first date but includes the second date. I also tried:

print (np.busday_count('2019-08-31', '2019-09-02', holidays=[]))

Result still = 0 despite attempt to clear any holidays. What am I missing?

sammy · Accepted Answer · 2019-12-04T22:36:20.117

1

As so often, the answer lies with the documentation and Python's love for half-open intervals:

Counts the number of valid days between begindates and enddates, not including the day of enddates.

edited Dec 04 '19 at 22:36

answered Dec 04 '19 at 22:30

sammy

I read that as well but then "print (np.busday_count('2019-07-31', '2019-08-01'))" = 1, shouldn't it = 0 if the end dates are not included? – Arthur D. Howland Dec 04 '19 at 22:32
Why? 2019-07-31 is a Wednesday, from what I see in my calendar. So, definitely a valid day. – sammy Dec 04 '19 at 22:33
I'll check, my logic may be backwards - it counts the first date but does not include the 2nd date. Kind of like 12am to 12am. – Arthur D. Howland Dec 04 '19 at 22:39
Um yes, just like regular slicing: the first item is included, the last item is excluded. – sammy Dec 04 '19 at 22:40
Checks out - the np.busday_count includes the first date but not the 2nd date. Thanks sammy – Arthur D. Howland Dec 04 '19 at 22:51

1 Answers1