Incorrect graph from Pandas plot

Question

Can anyone explain why the graph from the pandas plot doesn't display any of the numbers from the dataframe?

b = df_trend.ask[:10]
print b
0     100.86
2     100.85
3     100.84
4     100.84
5     100.85
7     100.85
9     100.85
11    100.84
12    100.85
14    100.85
Name: ask, dtype: float64

Output of the graph from using the plot method looks like this

b.plot()

what is incorrect? – MaxU - stand with Ukraine Mar 18 '16 at 16:26 — MaxU - stand with Ukraine, Mar 18 '16 at 16:26

score 0 · Accepted Answer · edited May 23 '17 at 12:07

0

For some odd reason pandas consider 100.xx as large number? Setting the offset to False solved the problem.

Wrong value in matplotlib yticks

edited May 23 '17 at 12:07

Community

1
1

answered Mar 18 '16 at 16:27

Zocr

93
1
6

more precisely, matplotlib considers the range of y-values (+/- 0.01) to be small relative to their magnitude (10^2) – Paul H Mar 18 '16 at 16:33
Understood. Thanks – Zocr Apr 01 '16 at 10:24

MaxU - stand with Ukraine · Answer 2 · 2016-03-18T16:36:13.047

0

pandas shows everything correctly - you can see it if you specify ylim parameter:

df.plot(ylim=(100.8, 100.9))

if you want to disable scientific notation use:

ax = df.plot(ylim=(100.8, 100.9))
ax.get_yaxis().get_major_formatter().set_useOffset(False)

plt.show()

edited Mar 18 '16 at 16:36

answered Mar 18 '16 at 16:29

MaxU - stand with Ukraine

205,989
36
386
419

Incorrect graph from Pandas plot

2 Answers2