How do I replace "." in my date to "-" in python when working with a data frame

Asked Dec 29 '22 at 23:18

Active Dec 29 '22 at 23:22

Viewed 36 times

I have the following data frame:

DATE

16.12.2022

15.12.2022

14.12.2022

13.12.2022

12.12.2022

I want to replace the "." in my DATE column with "-"

The current code I was using is as follows:

df2['DATE'] = df2['DATE'].replace('.','-')

But this would provide the following output:

0       ----------
1       ----------
2       ----------
3       ----------
4       ----------

All of the text in date has been replaced with "-"

Any suggestions as how I can make this work?

edited Dec 29 '22 at 23:22

mkrieger1

asked Dec 29 '22 at 23:18

KChemist

Try this https://stackoverflow.com/questions/38067704/how-to-change-the-datetime-format-in-pandas – Amal G Jose Dec 29 '22 at 23:21
1

do a print(df2.dtypes) and show us the reults – Je Je Dec 29 '22 at 23:23
result['DATE']= pd.to_datetime(result['DATE'], dayfirst=True) – Je Je Dec 29 '22 at 23:28

0 Answers0