String formatting of timedeltas in Pandas

Question

I noticed that Pandas knows how to smartly format a timedelta object into a string.

In [1]: df[column][rows].max()
Out[1]: 
0   2 days, 02:08:07
dtype: timedelta64[ns]

When I try to do this manually I keep getting the string in nanoseconds.

In [2]: df[column][rows].max()[0]
Out[2]: numpy.timedelta64(180487000000000,'ns')

In [2]: str(df[column][rows].max()[0])
Out[2]: '180487000000000 nanoseconds'

I would rather not reinvent the wheel, so is there any way to access the string formatting method (or the string itself) that Pandas uses to show a timedelta object in x days, hh:mm:ss ?

Andy Hayden · Accepted Answer · 2013-08-25T20:22:24.343

7

The function is located here:

pd.tslib.repr_timedelta64

In action:

In [11]: pd.tslib.repr_timedelta64(np.timedelta64(180487000000000,'ns'))
Out[11]: '2 days, 02:08:07'

edited Aug 25 '13 at 20:22

answered Aug 25 '13 at 20:09

Andy Hayden

359,921
101
625
535

Thanks! This is a useful function to have – Amelio Vazquez-Reina Aug 25 '13 at 20:12
4

May I ask, how did you know this was the function? Do you know the code base well? Pandas has some nice string formatting utilities, so it would be great to know how to browse them. – Amelio Vazquez-Reina Aug 25 '13 at 20:13
1

I had a feeling it would be in tslib (as I know the code base, and that is where timeseries stuff is), and found it with a tab complete :) – Andy Hayden Aug 25 '13 at 20:15
2

This solution got out-of-date and no longer works. – Maxim Egorushkin Jul 31 '22 at 22:54

String formatting of timedeltas in Pandas

1 Answers1

Linked