Difference between two date columns in a dataframe using python

Question

I have two columns in a dataframe in the format that it contains date and time as well. I need to find the difference in hours. When I try its giving type error.

Error: TypeError: unsupported operand type(s) for -: 'str' and 'str'.

Data example:

D1: 12/26/2014 7:45
    12/31/2014 6:30
D2: 1/1/2015 2:18
    1/1/2015 2:49

Need to find difference as D1-D2

Does this answer your question? Calculate Pandas DataFrame Time Difference Between Two Columns in Hours and Minutes — Pygirl
– Pygirl, Commented Jul 23, 2020 at 11:41

Nauman Akram · Accepted Answer · 2020-07-23 11:54:30Z

1

str function doesn't support it, you need to turn it into datetime format, look up about datetime module in python

official documentation: https://docs.python.org/3/library/datetime.html

answered Jul 23, 2020 at 11:54

Nauman Akram

111 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Difference between two date columns in a dataframe using python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related