X axis doesn't show when plotting dataframe

Question

Hi I have a dataframe with dates as index as shares as columns I want to plot a particular share using dates as x axis. The series I want to plot is : df['APPL']=

Date
2018-10-29    24.903347
2018-10-30    25.165384
2018-10-31    25.087744
2018-11-01    24.777180
...
2018-12-06    25.709999

But when I plot it out with df['APPL'].plot(use_index=True), the xasix is not showing. Then I tried plt.plot(df.index,df['APPL']), the interval of x axis is too small for it to be read. . How can I increase the interval to show every 10 days for example?

U13-Forward · Answer 1 · 2018-12-09T01:35:58.450

1

You can rotate:

plt.xticks(rotation=90)

Demo:

plt.plot(df.index,df['APPL'])
plt.xticks(rotation=90)

After rotating, the text would be rotated to 90 degrees.

And if you prefer:

plt.plot(df.index,df['APPL'])
plt.xticks(rotation=45)

Test which you like.

edited Dec 09 '18 at 01:35

answered Dec 09 '18 at 01:33

U13-Forward

69,221
14
89
114

1

Thanks but I would prefer to increase the interval to only show every 10 days for example. – Candice Dec 09 '18 at 01:35
@Candice You can set the number anytime, and whichever is the best for you, use it. – U13-Forward Dec 09 '18 at 01:36
1

Hi again.. i would prefer to increase the interval then use the rotation. :) Thanks – Candice Dec 09 '18 at 01:55
@Candice I don't understand what you mean about that – U13-Forward Dec 09 '18 at 01:57
1

as in reduce the frequency of x axis? instead of 2018-10-30 2018-10-31 2018-11-01.... I would like to show 2018-10-30, 2018-11-01,2018-11-11 etc – Candice Dec 09 '18 at 01:59
@Candice [this](https://stackoverflow.com/questions/12608788/changing-the-tick-frequency-on-x-or-y-axis-in-matplotlib) may help. – U13-Forward Dec 09 '18 at 02:00
1

Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/184949/discussion-between-candice-and-u9-forward). – Candice Dec 09 '18 at 02:04

score 1 · Accepted Answer · answered Dec 09 '18 at 03:02

Found to the solution, this code changes the interval to 3 days. Kudos to @U9-Forward and @wwii for pointing out my index was not datetime format.

df.index=pandas.to_datetime(df.index)
ax = df['APPL'].plot()
# set monthly locator
ax.xaxis.set_major_locator(mdates.DayLocator(interval=3))
# set formatter
ax.xaxis.set_major_formatter(mdates.DateFormatter('%d-%m-%Y'))
# set font and rotation for date tick labels
plt.gcf().autofmt_xdate()

X axis doesn't show when plotting dataframe

2 Answers2