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

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>
<pre class="brush:php;toolbar:false">             todate                 fromdate            diff  diff_in_hours

0 2014-01-24 13:03:12.050 2014-01-26 23:41:21.870 2 days 10:38:09.82 58
1 2014-01-27 11:57:18.240 2014-01-27 15:38:22.540 0 days 03:41:04.30 3
2 2014-01-23 10:07:47.660 2014-01-23 18:50:41.420 0 days 08:42:53.76 8

By utilizing this tailored method, you can efficiently convert the time difference between timestamps into hours and minutes, providing you with a more concise representation of the elapsed time.

The above is the detailed content of How to Calculate the Time Difference Between Two Pandas Columns in Hours and Minutes?. For more information, please follow other related articles on the PHP Chinese website!