Formatting datetime in dataframe

Question

I have a dataframe with number of different dates as index:

and i want to format them as MM-DD without changing the type to string. Can someone help me with that? And second question: If I do that, can I still use dt.dayofyear?

Hello and welcome. Please read the Stack Overflow question checklist. You might also want to learn about Minimal, Complete, and Verifiable Examples. — ArielGro
– ArielGro, Commented May 25, 2020 at 19:13

BENY · Accepted Answer · 2020-05-25 16:39:25Z

2

Simple way

df.index.str[5:]

More common way

df.index.strftime('%m-%d')

answered May 25, 2020 at 16:39

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Comment

Mateusz Piskorski Over a year ago

It works of course but object type changes from datetime64 to string and I don't want that

Collectives™ on Stack Overflow

Formatting datetime in dataframe

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related