Exclude weekends /holidays for calculating the time hour difference in pandas

Asked Nov 29 '19 at 12:37

Active Nov 29 '19 at 13:20

Viewed 570 times

here a some solutions around to calculate the day difference in python with excluding none business days (german business days):

But how can I apply this on a pandas dataframe, when I want to have the difference in hours and not in days?

When I try:

df['Diff'] = np.busday_count(df['end'], df['start'])

I receive the error:

TypeError: Iterator operand 0 dtype could not be cast from dtype('

So my target is to calculate:

start                end
2019-01-01 08:00:00  2019-01-08 08:00:00

Should lead to: df['Diff'] = 5*24 = 100

edited Nov 29 '19 at 12:42

asked Nov 29 '19 at 12:37

PV8

Do you need explude weekends or bussines days? – jezrael Nov 29 '19 at 12:41
I need business days, so weekends and holidays should be excludes, based on germany (for example christmas) – PV8 Nov 29 '19 at 12:42
Ok, please check dupe, if some problem let me know – jezrael Nov 29 '19 at 12:43
I will check the answer, it will be some pain, thx – PV8 Nov 29 '19 at 12:43
I think dupe answer was pain for creating for me. ;) – jezrael Nov 29 '19 at 12:44
1

It is crazy that there is no shortcut from pandas to it... – PV8 Nov 29 '19 at 12:48
1

I found a different work around, but it was also a pain ... – PV8 Nov 29 '19 at 13:49

0 Answers0