0

I need to convert a date in a .txt file that looks like '08-abr-19'.

The file is in Spanish so that's why April looks like 'abr' instead of 'apr'

I have tried using several formats as suggested in this site: http://strftime.org/

However, none of them seem to work. The most obvious to me was:

df['a'] = pd.to_datetime(df['a'],format='%d-%b-%y')

I get an error of this type: ValueError: time data '08-abr-19' does not match format '%d-%b-%y' (match)

As a note, I create a dataframe by importing the .txt file. Column 'a' contains the dates in the format I explained in the first line.

Any ideas?

teoeme139
  • 412
  • 3
  • 11

0 Answers0