Pandas plotting: How to format datetimeindex?

Question

I am doing a barplot out of a dataframe with a 15min datetimeindex over a couple of years. Using this code:

df_Vol.resample(
    'A',how='sum'
).plot.bar(
    title='Sums per year',
    style='ggplot',
    alpha=0.8
)

Unfortunately the ticks on the X-axis are now shown with the full timestamp like this: 2009-12-31 00:00:00.

I would prefer to Keep the code for plotting short, but I couldn't find an easy way to format the timestamp simply to the year (2009...2016) for the plot.

Can someone help on this?

Thanks EdChum, I was hoping there would be a Parameter like ('%Y') to Format this in the df.plot() command. — Markus W
– Markus W, Commented Aug 22, 2016 at 14:50

Markus W · Accepted Answer · 2016-08-25 11:45:15Z

4

As it does not seem to be possible to Format the date within the Pandas df.plot(), I have decided to create a new dataframe and plot from it.

The solution below worked for me:

df_Vol_new = df_Vol.resample('A',how='sum')
df_Vol_new.index = df_Vol_new.index.format(formatter=lambda x: x.strftime('%Y')) 
ax2 =df_Vol_new.plot.bar(title='Sums per year',stacked=True, style='ggplot', alpha=0.8)

answered Aug 25, 2016 at 11:45

Markus W

1,5035 gold badges19 silver badges32 bronze badges

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

Comments

atline · Accepted Answer · 2021-01-26 01:43:58Z

1

I figured an alternative (better, at least to me) way is to add the following to df_Vol_new.plot() command:

plt.legend(df_Vol_new.index.to_period('A'))

This way you would reserve df_Vol_new.index datetime format while getting better plots at the same time.

edited Jan 26, 2021 at 1:43

atline

32.1k19 gold badges102 silver badges134 bronze badges

answered Jan 25, 2021 at 21:27

Lei Z

211 bronze badge

Collectives™ on Stack Overflow

Pandas plotting: How to format datetimeindex?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related