Python: Convert timedelta to int in a dataframe

python pandas timedelta
Asaf Hanish picture Asaf Hanish · Sep 3, 2014 · Viewed 212.5k times · Source

I would like to create a column in a pandas data frame that is an integer representation of the number of days in a timedelta column. Is it possible to use 'datetime.days' or do I need to do something more manual?

timedelta column

7 days, 23:29:00

day integer column

7

Answer

abeboparebop picture abeboparebop · Feb 15, 2017

Use the dt.days attribute. Access this attribute via:

timedelta_series.dt.days

You can also get the seconds and microseconds attributes in the same way.

Related questions

calculate datetime-difference in years, months, etc. in a new pandas dataframe column

I have a pandas dataframe looking like this: Name start end A 2000-01-10 1970-04-29 I want to add a new column providing the difference between the start and end column in years, months, days. So the result should …

Read More
Python Pandas: TypeError: unsupported operand type(s) for +: 'datetime.time' and 'Timedelta'

I am attempting to add two series in a dataframe in pandas with the first series being a 24-hr time value (e.g. 17:30) exported from an excel file and the second series being a series of the same length in …

Read More
Python: Adding hours to pandas timestamp

I read a csv file into pandas dataframe df and I get the following: df.columns Index([u'TDate', u'Hour', u'SPP'], dtype='object') >>> type(df['TDate'][0]) <class 'pandas.tslib.Timestamp'> type(df['Hour'][0]) <type 'numpy.…

Read More