Converting datetime formatted index to date only python pandas

Question

I have a dataframe with an index formatted in datetime as such:

2019-01-01 00:00:00+00:00
2019-01-02 00:00:00+00:00
2019-01-03 00:00:00+00:00

I would like to only keep the year - month - day component without having to change the index back to a column and then back to index

Desired result:

2019-01-01
2019-01-02
2019-01-03

I have been struggling for quite some time. Hope this hasn't been asked before. Thanks for your input! :)

Ynjxsjmh · Accepted Answer · 2021-04-24 14:31:52Z

3

df.index = df.index.date

If your index is string not datetime type, convert it to datetime with

df.index = pd.to_datetime(df.index)

answered Apr 24, 2021 at 14:31

Ynjxsjmh

30.3k7 gold badges43 silver badges64 bronze badges

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

Comments

BENY · Accepted Answer · 2021-04-24 14:38:44Z

2

Try with

df['yourcol'] = df['col'].dt.date

Also if in the index

df.index = df.index.date

answered Apr 24, 2021 at 14:31

BENY

324k22 gold badges176 silver badges250 bronze badges