Limit Range on X Axis Scatter Plot Pandas MatplotLib

Question

I have a dataframe that is indexed based on time, with another column indicating the number of injured pedestrians during a crash occuring at that hour. I am trying to use Matplotlib in order to graph the data, and have successfully graphed it, however, the range is much too large. I have data for one day, and would like to set the x axis limit accordingly using the min and max values calculted. I have tried using plt.set_xlim but I get an error:

AttributeError: 'PathCollection' object has no attribute 'set_xlim'

How can the limit be properly set?

Graph without limits

df = test_request_pandas()
df1 = df[['time','number_of_pedestrians_injured']]
df1.set_index(['time'],inplace=True)
df1 = df1.astype(float)
min = df1.index.min()
max = df1.index.max()
fig = plt.scatter(df1.index.to_pydatetime(), df1['number_of_pedestrians_injured'])
#fig.set_xlim([min, max]) // causing me issues
plt.show()

Possible duplicate of [How do I change the range of the x-axis with datetimes in MatPlotLib?](http://stackoverflow.com/questions/21423158/how-do-i-change-the-range-of-the-x-axis-with-datetimes-in-matplotlib) — Ilya V. Schurov, Dec 21 '15 at 22:49

score 4 · Answer 1 · answered Dec 21 '15 at 21:33

4

You can create axes and then use ax.xlim().

import pandas as pd
df = pd.DataFrame({'x':[1,2,3], 'y':[3,4,5]})
fig = plt.figure()
ax = plt.subplot(111)
df.plot(x='x',y='y',ax=ax, kind='scatter')
ax.set_xlim(2,3)

answered Dec 21 '15 at 21:33

Ilya V. Schurov

7,687
2
40
78

1

@IIya V. Schurov What does the 111 mean? – Withoutahold Dec 21 '15 at 21:43
It creates a "subfigure matrix" with 1 row and 1 column. See details here: http://stackoverflow.com/questions/3584805/in-matplotlib-what-does-the-argument-mean-in-fig-add-subplot111 – Ilya V. Schurov Dec 21 '15 at 21:46
@IIya V. Schurov I get "KeyError:time" – Withoutahold Dec 21 '15 at 22:18
Using the command: df1.plot(x='time',y='number_of_pedestrians_injured', kind='scatter') – Withoutahold Dec 21 '15 at 22:18
It seems to be sideeffect of `df1.set_index(['time'],inplace=True)`: after you do it, column `time` disappears from the dataframe as it becomes index. – Ilya V. Schurov Dec 21 '15 at 22:34
1

You can still use `plt.scatter` instead of `df1.plot` as you do. For example, you can try `plt.xlim()` instead of `fig.set_xlim()` in your code. – Ilya V. Schurov Dec 21 '15 at 22:37
See also [this](http://stackoverflow.com/questions/21423158/how-do-i-change-the-range-of-the-x-axis-with-datetimes-in-matplotlib) question. – Ilya V. Schurov Dec 21 '15 at 22:46

score 3 · Answer 2 · answered Aug 24 '20 at 11:52

3

Use plt.xlim(min, max) instead.

answered Aug 24 '20 at 11:52

Robert Pollak

3,751
4
30
54

Limit Range on X Axis Scatter Plot Pandas MatplotLib

2 Answers2

Linked