CODEWITHSUNDEEP
python-3.xpandasdatetime
codebrotherone
codebrotherone

Reputation: 581

Out of bounds datetime error converting string using pd.to_datetime()

I am unable to convert a string in the format 'YYYYMMDD' to a datetime object due to an error. 

OutOfBoundsDatetime: Out of bounds nanosecond timestamp: 1-01-01 00:00:00

Here is some code snippets I am trying: enter image description here

When I try to do:

data.move_date = pd.to_datetime(data.move_date)

I get the above error. Does anyone know how to fix this? Is this a bug? I did the same exact operation with another column that was in the string format and it worked perfectly.

Upvotes: 1

Views: 1178

Answers (1)

Lucas Dresl
Lucas Dresl

Reputation: 1170

You can try this:

Adding @COLDSPEED answer

data['Dates'] = pd.to_datetime((data.move_data).apply(str),format='%Y%m%d', errors='coerce')

Upvotes: 2

Related Questions