how to extract days as integers from a timedelta64[ns] object in python

python timedelta
Blue Moon picture Blue Moon · Nov 9, 2015 · Viewed 17.5k times · Source

I have a pandas dataframe with a column like:

In [96]: data['difference']
Out[96]: 
0                 NaT
1     1 days 21:34:30
2     0 days 16:57:36
3     0 days 00:16:51
4     0 days 15:52:38
5     0 days 14:19:34
6     0 days 02:54:46
7     1 days 04:21:28
8     0 days 01:58:55
9     0 days 10:30:35
10    0 days 07:53:04
....
Name: difference, dtype: timedelta64[ns]

I want to create next to it a column with integers corresponding to the days values in this column.

Answer

Nhor picture Nhor · Nov 9, 2015

This should convert your timedelta64[ns] type to float64 representing days:

data['difference'].astype('timedelta64[D]')

Related questions

Adding days to a date in Python

I have a date "10/10/11(m-d-y)" and I want to add 5 days to it using a Python script. Please consider a general solution that works on the month ends also. I am using following code: import re from datetime import datetime …

Read More
Convert a timedelta to days, hours and minutes

I've got a timedelta. I want the days, hours and minutes from that - either as a tuple or a dictionary... I'm not fussed. I must have done this a dozen times in a dozen languages over the years but …

Read More
Format timedelta to string

I'm having trouble formatting a datetime.timedelta object. Here's what I'm trying to do: I have a list of objects and one of the members of the class of the object is a timedelta object that shows the duration of …

Read More