How to format the string values without space to datetime in python?

Asked Feb 10 '23 at 20:06

Active Feb 10 '23 at 20:06

Viewed 25 times

i have a pandas df:

The dates are string and are formatted as %Y%M%D

I want to format the entire column to %D%M%Y. Like this:

I tried the datetime doule and other custom formating.

asked Feb 10 '23 at 20:06

Claudio_TS

Use `date.strptime()` to parse the datees and `date.strftime()` to format them. – Barmar Feb 10 '23 at 20:11
"I tried..." what? Show your coding attempt. – Mark Tolonen Feb 10 '23 at 20:13
1

`df['Date'] = pd.to_datetime(df['Date'], format='%Y%m%d').dt.strftime('%d-%m-%Y')` – mozway Feb 10 '23 at 20:15
Breaking the string into 3 pieces and calling `int` on each would be dead simple. – Mark Ransom Feb 10 '23 at 20:47

0 Answers0