Dates in X-axis using pandas and matplotlib

Question

I am trying to plot some data from pandas. First I group by weeks and count for each grouped week, them I want to plot for each date, however when I try to plot I get just some dates, not all of them.

I am using the following code:

my_data = res1.groupby(pd.Grouper(key='d', freq='W-MON')).agg('count').u
p1,  = plt.plot(my_data, '.-')
a = plt.xticks(rotation=45)

My result is the following:

I wanted a value in the x-axis for each date in the grouped dataframe.

EDIT: I tried to use plt.xticks(list(my_data.index.astype(str)), rotation=45) The plot I get is the following:

you can simply put the list of dates you want to display for each point in plt.xticks(dates) — quest
– quest, Commented Oct 9, 2018 at 8:37
I tried doing that, however instead of having the whole dates I get just the year — Jorge Rodriguez Molinuevo
– Jorge Rodriguez Molinuevo, Commented Oct 9, 2018 at 8:40
You would benefit from creating a minimal reproducible example of the issue, such that people can give an answer which actually suits your needs. — ImportanceOfBeingErnest
– ImportanceOfBeingErnest, Commented Oct 9, 2018 at 9:21

quest · Accepted Answer · 2018-10-09 08:56:43Z

1

Please find a working chunk of code below:

from datetime import date, timedelta
import matplotlib.pyplot as plt
import matplotlib.dates as mdates
import numpy as np

a = pd.Series(np.random.randint(10, 99, 10))

plt.gca().xaxis.set_major_formatter(mdates.DateFormatter('%m/%d/%Y'))
plt.gca().xaxis.set_major_locator(mdates.DayLocator())

plt.plot(pd.date_range(date(2016,1,1), periods=10, freq='D'), a)
plt.gcf().autofmt_xdate()

Hope it helps :)

answered Oct 9, 2018 at 8:56

quest

3,9662 gold badges18 silver badges27 bronze badges

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

4 Comments

ImportanceOfBeingErnest Over a year ago

If you generate the data with freq='D', using a DayLocator is reasonable for ticking each date that occurs in the data. What if the frequency is different? This is what the question asks about as I understand it.

Jorge Rodriguez Molinuevo Over a year ago

i wasn't able to make this work, however plt.xticks(list(my_data.index.astype(str)), list(my_data.index.astype(str)), rotation=45) worked for me

quest Over a year ago

@ImportanceOfBeingErnest valid point, depending upon the frequency DayLocator, MonthLocator, YearLocator etc had to be used.

quest Over a year ago

@JorgeRodriguezMolinuevo: your way is must succinct, indeed

Collectives™ on Stack Overflow

Dates in X-axis using pandas and matplotlib

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related