Change DateTime Format - Python

Question

I have a dataframe with a Date as the Index. Initally my index is of the form %Y-%m-%d and the type is datetime64[ns]. I would like to change the format to %Y-%d-%m but continue to have an index of type datetime64[ns]. My problem is that when I change the format with

data.index = pd.to_datetime(data.index).strftime('%Y-%d-%m')
#or
data.index  = data.index.strftime('%Y-%d-%m')

it changes the type of the index to 'object' and I am not able to change it back.

To change it back I tried

data.index = pd.to_datetime(data.index)

but I get the error "month must be in 1..12: 2017-13-01".

Thanks a lot in advance!

TheFaultInOurStars · Accepted Answer · 2022-03-27 15:35:19Z

1

I guess you should try something like:

data.index = pd.to_datetime(data.index, format='%Y-%d-%m')

answered Mar 27, 2022 at 15:35

TheFaultInOurStars

3,6331 gold badge13 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

Change DateTime Format - Python

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related