Pandas: Exception while plotting two data frames on the same graph

Question

I have two Pandas DataFrame that I am trying to plot on the same graph.

all_data: need to plot this as a line graph
points_of_interest: need to plot this as a scatter plot in the same graph

Here is the code that I use to plot them:

axes = all_data[ASK_PRICE].plot(figsize=(16, 12))
points_of_interest[ASK_PRICE].plot(figsize=(16, 12), ax = axes, kind='scatter')
pylab.show()

When I run this code it says:

>>> points_of_interest[ASK_PRICE].plot(figsize=(16, 12), ax = axes, kind='scatter')
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/home/shubham/.local/lib/python2.7/site-packages/pandas/tools/plotting.py", line 3599, in __call__
**kwds)
  File "/home/shubham/.local/lib/python2.7/site-packages/pandas/tools/plotting.py", line 2673, in plot_series
**kwds)
  File "/home/shubham/.local/lib/python2.7/site-packages/pandas/tools/plotting.py", line 2430, in _plot
% kind)
ValueError: plot kind 'scatter' can only be used for data frames

I have confirmed that both the dataframes are of type 'DataFrame'. What am I missing?

piRSquared · Accepted Answer · 2016-10-21 14:53:14Z

1

you are trying to use the pd.Series points_of_interest[ASK_PRICE] with plot(kind='scatter'). You assumed it would naturally take the index vs the values. That is unfortunately not true.

Try this

axes = all_data[ASK_PRICE].plot(figsize=(16, 12))
poi = points_of_interest[ASK_PRICE]
poi.reset_index().plot.scatter(0, 1, ax=axes)
pylab.show()

answered Oct 21, 2016 at 14:53

piRSquared

296k68 gold badges509 silver badges654 bronze badges

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

Collectives™ on Stack Overflow

Pandas: Exception while plotting two data frames on the same graph

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related