Two bar plots in one graph from different dataframes (one common column)

Question

I have two simple data frames

1.

count type
400   customer
1200  subscriber

2.

count type
2000  customer
5000  subscriber

I am trying to make bar plot with one figure.

X axis: customer - customer, subscriber - subscriber -> same type next to each other)

Y axis: count

I tried

df1.plot.bar()
df2.plot.bar()

and stuck here.

w-m · Accepted Answer · 2019-06-07 08:56:40Z

2

You will want to merge the data together:

combined = df1.merge(df2, on="type", suffixes=["1", "2"]).set_index("type")

Then you can plot them with one call:

combined.plot.bar()

answered Jun 7, 2019 at 8:56

w-m

11.3k1 gold badge46 silver badges51 bronze badges

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

Comments

Sheldore · Accepted Answer · 2019-06-07 10:49:48Z

1

I like the other elegant answer. However, since you have tagged matplotlib, you might be interested in knowing a corresponding solution. The idea here is to align the bars to the edges of major ticks and then use negative and positive width to shift them left/right.

P.S: This is a tailored solution for plotting two bars adjacently. In principle, this can be made general to plot multiple bars.

import matplotlib.pyplot as plt

plt.bar(df1['type'], df1['count'], align='edge', width=-0.3, label='count1')
plt.bar(df2['type'], df2['count'], align='edge', width=0.3, label='count2')

plt.legend()

answered Jun 7, 2019 at 10:49

Sheldore

39.2k9 gold badges63 silver badges76 bronze badges

Collectives™ on Stack Overflow

Two bar plots in one graph from different dataframes (one common column)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related