pandas out of bounds nanosecond timestamp after offset rollforward plus adding a month offset

by

Since pandas represents timestamps in nanosecond resolution, the timespan that can be represented using a 64-bit integer is limited to approximately 584 years

pd.Timestamp.min
Out[54]: Timestamp('1677-09-22 00:12:43.145225')

In [55]: pd.Timestamp.max
Out[55]: Timestamp('2262-04-11 23:47:16.854775807')

And your value is out of this range 2262-05-01 00:00:00 and hence the outofbounds error

Straight out of: http://pandas-docs.github.io/pandas-docs-travis/user_guide/timeseries.html#timeseries-timestamp-limits

Workaround:

This will force the dates which are outside the bounds to NaT

pd.to_datetime(date_col_to_force, errors="coerce")

More Related Contents:

  1. Converting between datetime, Timestamp and datetime64
  2. How to join two dataframes for which column values are within a certain range?
  3. Calculate Time Difference Between Two Pandas Columns in Hours and Minutes
  4. Convert Excel style date with pandas
  5. Combine Date and Time columns using python pandas
  6. datetime to string with series in pandas
  7. pandas datetime to unix timestamp seconds
  8. How to convert columns into one datetime column in pandas?
  9. python pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  10. How to group a pandas dataframe by a defined time interval?
  11. Python Pandas Group by date using datetime data
  12. Removing the timestamp from a datetime in pandas dataframe
  13. Subtract a year from a datetime column in pandas
  14. Pandas: Return Hour from Datetime Column Directly
  15. pandas .plot() x-axis tick frequency — how can I show more ticks?
  16. Convert a column of datetimes to epoch in Python
  17. Pandas: How to create a datetime object from Week and Year?
  18. How to define format when using pandas to_datetime?
  19. pd.Timestamp versus np.datetime64: are they interchangeable for selected uses?
  20. pandas bar plot combined with line plot shows the time axis beginning at 1970
  21. how to test if a variable is pd.NaT?
  22. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  23. Python pandas integer YYYYMMDD to datetime
  24. Python: Datetime to season
  25. filter pandas dataframe by time
  26. Average time for datetime list
  27. How to combine year, month, and day columns to single datetime column?
  28. How do I convert timestamp to datetime.date in pandas dataframe?
  29. Pandas datetimes with different formats in the same column
  30. Get weekday/day-of-week for Datetime column of DataFrame

Leave a Comment