How to Calculate the Time Difference Between Two Pandas Columns in Hours and Minutes?

Calculate Time Difference Between Two Pandas Columns in Hours and Minutes

To compute the time difference between two Pandas columns in hours and minutes, you can leverage the astype method on the datetime.timedelta returned by the Pandas timestamp difference. Here's a detailed explanation:

import pandas</p><h1>Create a sample dataframe with 'todate' and 'fromdate' columns</h1><p>data = {'todate': [pd.Timestamp('2014-01-24 13:03:12.050000'), pd.Timestamp('2014-01-27 11:57:18.240000'), pd.Timestamp('2014-01-23 10:07:47.660000')],</p><div class="code" style="position:relative; padding:0px; margin:0px;"><pre class="brush:php;toolbar:false">    'fromdate': [pd.Timestamp('2014-01-26 23:41:21.870000'), pd.Timestamp('2014-01-27 15:38:22.540000'), pd.Timestamp('2014-01-23 18:50:41.420000')]}

Copy after login

df = pd.DataFrame(data)

Calculate the time difference between the two columns

df['diff'] = df['fromdate'] - df['todate']

Convert the difference to hours using the as_type method

df['diff_in_hours'] = df['diff'].astype('timedelta64[h]')

This approach generates the following output, with the time difference expressed in hours:

</p>
<div class="code" style="position:relative; padding:0px; margin:0px;"><pre class="brush:php;toolbar:false">             todate                 fromdate            diff  diff_in_hours

Copy after login