Replace values from column in Pandas dataframe

Question

Inside my Pandas dataframe, my 'Date' columns have strings of the format mm/dd/yyyy. What I want to do is convert them into YYYY-dd-mm.

df = pd.read_csv(csv_file, header=1)

date_list = df['Date'].values
for item in date_list:
    item = pd.to_datetime(item).strftime('%Y-%m-%d')
    print(item)

This code converts the dates successfully, but the dataframe is not changed. How can I make it change the dataframe with the new format?

jezrael · Accepted Answer · 2019-07-07 15:21:52Z

2

Better here is use to_datetime with all column values and then Series.dt.strftime with change format to %Y-%d-%m:

df['Date'] = pd.to_datetime(df['Date']).dt.strftime('%Y-%d-%m')

answered Jul 7, 2019 at 15:21

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Replace values from column in Pandas dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related