Pandas date convesrion unconverted data remains

adobro 0
Viewed 17

In Pandas (Juypter) I have a column with dates in string format:

koncerti.Date.values[:20]
array(['15 September 2010', '16 September 2010', '18 September 2010',
       '20 September 2010', '21 September 2010', '23 September 2010',
       '24 September 2010', '26 September 2010', '28 September 2010',
       '30 September 2010', '1 October 2010', '3 October 2010',
       '5 October 2010', '6 October 2010', '8 October 2010',
       '10 October 2010', '12 October 2010', '13 October 2010',
       '15 October 2010', '17 October 2010'], dtype=object)

I try to convert them to date format with the following statement:

koncerti.Date = pd.to_datetime(koncerti.Date, format='%d %B %Y')

Unfortunatelly, it produces the following error: ValueError: unconverted data remains: [31]

What does it mean this error?

datetime pandas python
1 Answers

Solution: koncerti.Date = pd.to_datetime(koncerti.Date, format='%d %B %Y', exact=False)

Addditional parameter was needed: exact=False

adobro0
Related