Cannot convert string to datetime datatype using pandas to_datetime method

Question

I'm having a hard time with pd.to_datetime() in Python 3 on Anaconda. Hopefully it's a simple fix, but it's saying that the issue is the data is a series type and not a DataFrame. Can someone please let me know if there's a quick fix to this?

This is the code that's giving me an error:

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

This is the error I'm getting:

Here is the code where the data is wrangled:

When I use .reset_index, as recommended, I get the following error: --------------------------------------------------------------------------- NameError Traceback (most recent call last) <ipython-input-54-6c150d3816f1> in <module> ----> 1 Confirmed_Date_test.reset_index(inplace=true) NameError: name 'true' is not defined — Jonathan Ambriz
– Jonathan Ambriz, Commented Apr 29, 2020 at 20:44
When I use .reset_index() without inplace parameter, it works. The original error remains the same. — Jonathan Ambriz
– Jonathan Ambriz, Commented Apr 29, 2020 at 20:46

Renaud · Accepted Answer · 2020-04-29 20:29:49Z

2

Observation Date is the index of your groupby result. Add a reset index before the pd.todatetime():

Confirmed_Date_test.reset_index(inplace=true)

answered Apr 29, 2020 at 20:29

Renaud

2,8172 gold badges12 silver badges25 bronze badges

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

Comments

Jonathan Ambriz · Accepted Answer · 2020-04-29 22:40:27Z

0

It was resolved by adding .to_frame() to the end of the ln 39.

answered Apr 29, 2020 at 22:40

Jonathan Ambriz

291 silver badge7 bronze badges

Collectives™ on Stack Overflow

Cannot convert string to datetime datatype using pandas to_datetime method

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related