How to properly add hours to a pandas.tseries.index.DatetimeIndex?

by

You can use pd.DateOffset:

test[1].index + pd.DateOffset(hours=16)

pd.DateOffset accepts the same keyword arguments as dateutil.relativedelta.

The problem you encountered was due to this bug which has been fixed in Pandas version 0.14.1:

In [242]: pd.to_timedelta(16, unit="h")
Out[242]: numpy.timedelta64(16,'ns')

If you upgrade, your original code should work.

Related Contents:

  1. How are iloc and loc different?
  2. How to convert index of a pandas dataframe into a column
  3. Selecting a row of pandas series/dataframe by integer index
  4. How to reset index in a pandas dataframe? [duplicate]
  5. Get column index from column name in python pandas
  6. pandas: multiple conditions while indexing data frame – unexpected behavior
  7. Python Pandas: Get index of rows where column matches certain value
  8. What rules does Pandas use to generate a view vs a copy?
  9. Pandas split DataFrame by column value
  10. Apply Function on DataFrame Index
  11. Forcing pandas .iloc to return a single-row dataframe?
  12. start index at 1 for Pandas DataFrame
  13. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  14. Select only one index of multiindex DataFrame
  15. pandas – change df.index from float64 to unicode or string
  16. Pandas – Compute z-score for all columns
  17. Pandas (python): How to add column to dataframe for index?
  18. In Python pandas, start row index from 1 instead of zero without creating additional column
  19. Set MultiIndex of an existing DataFrame in pandas
  20. Accessing a Pandas index like a regular column
  21. Pandas Resampling error: Only valid with DatetimeIndex, TimedeltaIndex or PeriodIndex
  22. Pandas finding local max and min
  23. obtaining last value of dataframe column without index
  24. Pandas KeyError: value not in index
  25. Pandas compare next row
  26. Selecting last n columns and excluding last n columns in dataframe
  27. Convert Pandas column containing NaNs to dtype `int`
  28. How to plot two columns of a pandas data frame using points
  29. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  30. Get the name of a pandas DataFrame
  31. Pandas – Filtering None Values
  32. Good alternative to Pandas .append() method, now that it is being deprecated?
  33. Resampling Within a Pandas MultiIndex
  34. Calculate time difference between Pandas Dataframe indices
  35. Running get_dummies on several DataFrame columns?
  36. Using .loc with a MultiIndex in pandas
  37. Filtering all rows with NaT in a column in Dataframe python
  38. Pandas DataFrame Add column to index without resetting
  39. python pandas dataframe slicing by date conditions
  40. Max and Min date in pandas groupby
  41. Calculate summary statistics of columns in dataframe
  42. Apply CSS class to Pandas DataFrame using to_html
  43. Split cell into multiple rows in pandas dataframe
  44. Remove name, dtype from pandas output of dataframe or series
  45. python pandas pivot_table count frequency in one column
  46. How to resample a dataframe with different functions applied to each column?
  47. Convert month int to month name in Pandas
  48. Python pandas: output dataframe to csv with integers
  49. Pandas: create dataframe from list of namedtuple
  50. Select certain rows by index of another DataFrame

Leave a Comment