Plot Multiple DataFrames into one single plot

Question

I have two dataFrames that I would like to plot into a single graph. Here's a basic code:

#!/usr/bin/python

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt

scenarios = ['scen-1', 'scen-2']

for index, item in enumerate(scenarios):
    df = pd.DataFrame({'A' : np.random.randn(4)})
    print df

df.plot()
plt.ylabel('y-label')
plt.xlabel('x-label')
plt.title('Title')
plt.show()

However, this only plots the last dataFrame. If I use pd.concat() it plots one line with the combined values. How can I plot two lines, one for the first dataFrame and one for the second one?

Could you provide an image of what you mean by two plots in one graph? What I understand is that you want two or more plots in one figure, am I right? But also I saw the comment you made to one of the answers that you want both plots as if it was one, and I don't seem to understand what you want. Do you want a graph were one 'x value' has multiple 'y values'? Like in a candlestick chart? — ccolin
– ccolin, Commented Jan 9, 2018 at 18:03
There's a question I have already answered about multiple plots in one figure, have a look: stackoverflow.com/questions/48125674/… — ccolin
– ccolin, Commented Jan 9, 2018 at 18:05

Little Bobby Tables · Accepted Answer · 2018-01-09 22:49:53Z

3

You need to put your plot in the for loop.

If you want them on a single plot then you need to use plot's ax kwarg to put them to plot on the same axis. Here I have created a fresh axis using subplots but this could be an already populated axis,

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt

scenarios = ['scen-1', 'scen-2']

fig, ax = plt.subplots()

for index, item in enumerate(scenarios):
    df = pd.DataFrame({'A' : np.random.randn(4)})
    print df
    df.plot(ax=ax)

plt.ylabel('y-label')
plt.xlabel('x-label')
plt.title('Title')
plt.show()

edited Jan 9, 2018 at 22:49

answered Jan 9, 2018 at 17:52

Little Bobby Tables

4,8146 gold badges34 silver badges51 bronze badges

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

3 Comments

user8200327 Over a year ago

Thanks Josh. But putting df.plot() inside the loop yield two plots. I want both on the same plot.

Little Bobby Tables Over a year ago

@AdhySatya editted to include this - i see it in your question now :)

user8200327 Over a year ago

@josh that worked, thanks. I made a small fix, it should be subplots()

Michael H. · Accepted Answer · 2018-01-09 17:53:32Z

0

The plot function is only called once, and as you say this is with the last value of df. Put df.plot() inside the loop.

answered Jan 9, 2018 at 17:53

Michael H.

3,5132 gold badges27 silver badges31 bronze badges

Collectives™ on Stack Overflow

Plot Multiple DataFrames into one single plot

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related