DreamAwake DreamAwake - 1 year ago 498
Python Question

How to add/subtract time (hours, minutes, etc.) from a Pandas DataFrame.Index whos objects are of type datetime.time?

I've got a DataFrame who's index is just datetime.time and there's no method in DataFrame.Index and datetime.time to shift the time. datetime.time has replace but that'll only work on individual items of the Series?

Here's an example of the index used:

In[526]: dfa.index[:5]
Out[526]: Index([21:12:19, 21:12:20, 21:12:21, 21:12:21, 21:12:22], dtype='object')

In[527]: type(dfa.index[0])
Out[527]: datetime.time

Answer Source

Liam's link looks great, but also check out pandas.Timedelta - looks like it plays nicely with NumPy's and Python's time deltas.

http://pandas.pydata.org/pandas-docs/dev/timedeltas.html

pd.date_range('2014-01-01', periods=10) + pd.Timedelta(days=1)