Pandas.plot Multiple plot same figure

Question

I have multiple CSV files that I am trying to plot in same the figure to have a comparison between them. I already read some information about pandas problem not keeping memory plot and creating the new one every time. People were talking about using an ax var, but I do not understand it...

For now I have:

def scatter_plot(csvfile,param,exp):
    for i in range (1,10):
        df = pd.read_csv('{}{}.csv'.format(csvfile,i))
        ax = df.plot(kind='scatter',x=param,y ='Adjusted')
        df.plot.line(x=param,y='Adjusted',ax=ax,style='b')
    plt.show()
    plt.savefig('plot/{}/{}'.format(exp,param),dpi=100)

But it's showing me ten plot and only save the last one. Any idea?

(1) plt.savefig needs to come before plt.show. (2) plt.show() should be outside the loop. (3) You can create an axes to plot to outside the loop, ax=plt.gca(); for i in range(1,10): ... df.plot(ax=ax) — ImportanceOfBeingErnest
– ImportanceOfBeingErnest, Commented Nov 28, 2017 at 21:26

ImportanceOfBeingErnest · Accepted Answer · 2017-11-28 21:37:51Z

10

The structure is

create an axes to plot to
run the loop to populate the axes
save and/or show (save before show)

In terms of code:

import matplotlib.pyplot as plt
import pandas as pd

ax = plt.gca()
for i in range (1,10):
    df = pd.read_csv(...)
    df.plot(..., ax=ax)
    df.plot.line(..., ax=ax)

plt.savefig(...)
plt.show()

answered Nov 28, 2017 at 21:37

ImportanceOfBeingErnest

342k61 gold badges738 silver badges771 bronze badges

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

4 Comments

Boat Over a year ago

Thanks for that really appreciate. One thing remains is that when I save the figure it only select the last one. And only the figure one has all the plot.

ImportanceOfBeingErnest Over a year ago

In the code from my answer there is only one single figure and that figure is saved.

Boat Over a year ago

weird using the exact same code keeps showing me 10 figures.

Boat Over a year ago

Okay got it forgot the ax=ax for the first plot. Thanks again.

Collectives™ on Stack Overflow

Pandas.plot Multiple plot same figure

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related