Calculate Time Difference Between Two Pandas Columns in Hours and Minutes

by

Pandas timestamp differences returns a datetime.timedelta object. This can easily be converted into hours by using the *as_type* method, like so

import pandas
df = pandas.DataFrame(columns=['to','fr','ans'])
df.to = [pandas.Timestamp('2014-01-24 13:03:12.050000'), pandas.Timestamp('2014-01-27 11:57:18.240000'), pandas.Timestamp('2014-01-23 10:07:47.660000')]
df.fr = [pandas.Timestamp('2014-01-26 23:41:21.870000'), pandas.Timestamp('2014-01-27 15:38:22.540000'), pandas.Timestamp('2014-01-23 18:50:41.420000')]
(df.fr-df.to).astype('timedelta64[h]')

to yield,

0    58
1     3
2     8
dtype: float64

More Related Contents:

  1. Changing the formatting of a datetime axis in matplotlib
  2. How do I round datetime column to nearest quarter hour
  3. Keep only date part when using pandas.to_datetime
  4. Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
  5. Convert Excel style date with pandas
  6. datetime dtypes in pandas read_csv
  7. How to convert string to datetime format in pandas python?
  8. How to make a timezone aware datetime object
  9. pandas dataframe groupby datetime month
  10. Find the end of the month of a Pandas DataFrame Series
  11. Create a day-of-week column in a Pandas dataframe using Python
  12. Pandas: Subtracting two date columns and the result being an integer
  13. Converting between datetime and Pandas Timestamp objects
  14. Splitting timestamp column into separate date and time columns
  15. Pandas: Datetime Improperly selecting day as month from date [duplicate]
  16. Why is pandas.to_datetime slow for non standard time format such as ‘2014/12/31’
  17. Pandas converting row with unix timestamp (in milliseconds) to datetime
  18. Python pandas convert datetime to timestamp effectively through dt accessor
  19. Specifying date format when converting with pandas.to_datetime
  20. Which is the fastest way to extract day, month and year from a given date?
  21. Locate first and last non NaN values in a Pandas DataFrame
  22. Datetime conversion – How to extract the inferred format?
  23. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  24. What values are valid in Pandas ‘Freq’ tags?
  25. Clean way to convert quarterly periods to datetime in pandas
  26. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  27. Convert dates to pd.to_datetime where month could be either a number or month name
  28. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  29. Pandas: groupby forward fill with datetime index
  30. Pandas: select all dates with specific month and day

Leave a Comment