Edit date value within a dataframe

Question

I have this Dataframe and the date is in the following format: '2020-08-01'

I would like to write a loop that iterates on each line and performs the switch to the following format: '01/08'

I’m using the Jupyter, pandas... thank you very much

Answer 1

Pandas has the strftime function if it can convert the date to a string with the format you want. Link to documentation.

df["Date"].dt.strftime("%d/%m/%y")

Answer 2

You can use the Pandas apply function.

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.apply.html

Example:

def convert_data(dt):
    # Formata a data aqui
    return new_dt

df['date'] = df['date'].apply(convert_data)