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

Question

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:

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.

Lucas Dresl · Accepted Answer · 2017-12-15 20:25:49Z

2

You can try this:

Adding @COLDSPEED answer

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

edited Dec 15, 2017 at 20:25

answered Dec 15, 2017 at 20:16

Lucas Dresl

1,1701 gold badge11 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

cs95 Over a year ago

pd.to_datetime(..., format='%Y%m%d', errors='coerce')

codebrotherone Over a year ago

@COLDSPEED, that worked thank you! So I'm guessing what we did was ignore all problematic rows. Is there a way to view which rows these are??

BENY Over a year ago

@codebrotherone usingdf[pd.to_datetime(..., format='%Y%m%d', errors='coerce') .isnull()] to search back you original df

Lucas Dresl Over a year ago

@codebrotherone if the answer helped can you plz upvote the answer plz? :)

Collectives™ on Stack Overflow

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

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related