Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Plot two pandas data frames side by side, each in subplot style

I want to plot two pandas dataframes side by side, each plot should be in subplot form. I am using following lines:

import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
# create dummy pandas dataframes
pd1 = pd.DataFrame({'a':np.random.random(22),'b':np.random.random(22),'c':np.random.random(22)})
pd2 = pd.DataFrame({'J':np.random.random(22),'K':np.random.random(22),'P':np.random.random(22)})
#create subplot figure with having two side by side plots
fig, axes = plt.subplots(nrows=1,ncols=2,figsize=(12,6))
# plot first pandas frame in subplot style
pd1.plot(ax = axes[0],subplots=True) 
# plot second pandas frame in subplot style
pd2.plot(ax = axes[1],subplots=True)

Without subplot option, side by side plots are drawn but I want in subplot style. Is there any other option to get it done?

Precisely, I want to plot pandas in the following manner: enter image description here

like image 710
Haroon Rashid Avatar asked Feb 27 '18 10:02

Haroon Rashid


People also ask

How can I plot separate pandas DataFrames as subplots?

You can manually create the subplots with matplotlib, and then plot the dataframes on a specific subplot using the ax keyword. For example for 4 subplots (2x2): import matplotlib. pyplot as plt fig, axes = plt.

How do you plot multiple data frames?

To plot multiple data columns in single frame we simply have to pass the list of columns to the y argument of the plot function.


1 Answers

You need a subplot grid of 3 rows and 2 columns to host your plot. Then the ax argument needs to take the 3 axes you want to plot the 3 dataframe columns to.

fig, axes = plt.subplots(nrows=3,ncols=2)
pd1.plot(ax = axes[:,0], subplots=True) 
pd2.plot(ax = axes[:,1], subplots=True)

Complete code:

import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
# create dummy pandas dataframes
pd1 = pd.DataFrame({'a':np.random.random(22),'b':np.random.random(22),
                    'c':np.random.random(22)})
pd2 = pd.DataFrame({'J':np.random.random(22),'K':np.random.random(22),
                    'P':np.random.random(22)})
#create subplot figure with having two side by side plots
fig, axes = plt.subplots(nrows=3,ncols=2,figsize=(12,6))
# plot first pandas frame in subplot style
pd1.plot(ax = axes[:,0],subplots=True) 
# plot second pandas frame in subplot style
pd2.plot(ax = axes[:,1],subplots=True)

plt.show()

enter image description here

like image 97
ImportanceOfBeingErnest Avatar answered Oct 16 '22 19:10

ImportanceOfBeingErnest