CODEWITHSUNDEEP
pythonpandasdataframeopenpyxl
sanjay_siddharth
sanjay_siddharth

Reputation: 33

Convert dtype:object with dates over '2262-04-11' to int in Pandas?

I am doing data analysis in Python where the input is an Excel file. There is a column ["Expiry"] where the dates are from "1999-01-01" to "9999-12-31" . The date column is taken in as dtype:object .

Using Pandas , there is a limitation that the maximum range of datetime is '2262-04-11'.

Is there a way to bypass this or convert the date values in the range between "2262-04-11" and "9999-12-31" to "2262-04-11" and continue with the analysis ?

Asking this because currently the date values above "2262-04-11" are discarded as NA and I dont want that because there are already "Blanks" and "NA" values in the raw data which cannot be filtered.

I need the output to be in datetime itself as I want to perform further manipulations on it! If possible can we convert it into an int ?

I have tried most methods but mostly everything results in "Overflow datetime" error

Upvotes: -1

Views: 33

Answers (0)

Related Questions