Series of datetime string to string format %d-%m-%Y

Question

What I'm looking for is a dataframe that has a date column, but it does not have the data type datetime64ns, it currently has type object with the following format YYYY-mm-DD I need to change this format to d-m-Y

0     2019-05-14 
1     2019-05-14
2     2019-05-14
3     2019-05-14
4     2019-05-14

dataframe['fefuente'].apply(lambda x: f'{x:%d-%m-%Y}') I currently have this code, but I get the following error ValueError: Invalid format specifier

what he sought to obtain is something like this

0     14-05-2019
1     14-05-2019
2     14-05-2019
3     14-05-2019
4     14-05-2019

@WeNYoBen Is there a real need to first convert the column to datetime? — kmiiloberrio-dev, May 23 '19 at 00:59

score 2 · Accepted Answer · answered May 23 '19 at 00:49

2

You first need to convert the column to a datetime object.

dataframe['fefuente'] = pd.to_datetime(dataframe['fefuente'])

Then, as WeNYoBen said, you format the datetime.

dataframe['new_date']= dataframe['fefuente'].dt.strftime('%d-%m-%Y')

answered May 23 '19 at 00:49

Guilherme Felitti

84
10

1

Is there a real need to first convert the column to datetime? – kmiiloberrio-dev May 23 '19 at 01:09
Yes. Otherwise, Pandas will not be capable of formating it to the desired date. – Guilherme Felitti May 23 '19 at 01:55

Series of datetime string to string format %d-%m-%Y

1 Answers1