How to plot two DataFrame on same graph for comparison

Question

I have two DataFrames (trail1 and trail2) with the following columns: Genre, City, and Number Sold. Now I want to create a bar graph of both data sets for a side by side comparison of Genre vs. total Number Sold. For each genre, I want to two bars: one representing trail 1 and the other representing trail 2.

How can I achieve this using Pandas?

I tried the following approach which did NOT work.

gf1 = df1.groupby(['Genre'])
gf2 = df2.groupby(['Genre']) 
gf1Plot = gf1.sum().unstack().plot(kind='bar, stacked=False)
gf2Plot = gf2.sum().unstack().plot(kind='bar, ax=gf1Plot, stacked=False)

I want to be able to see How trail1 data set compared to trial2 data for each of the Genre (ex: Spicy, Sweet, Sour, etc...)

I also tried using concat, but I can't figure out how to graph the concatenated DataFrame on the same graph to compare the two keys.

DF = pd.concat([df1,df2],keys=['trail1','trail2'])

Zythyr · Accepted Answer · 2015-07-07 19:26:40Z

11

I found a solution to my question. I welcome others to post a better approach.

Solution:

df1 = pd.DataFrame(myData1, columns=['Genre', 'City', 'Sold'])
df2 = pd.DataFrame(myData2, columns=['Genre', 'City', 'Sold'])

df1['Key'] = 'trail1'
df2['Key'] = 'trail2'

DF = pd.concat([df1,df2],keys=['trail1','trail2'])

DFGroup = DF.groupby(['Genre','Key'])

DFGPlot = DFGroup.sum().unstack('Key').plot(kind='bar')

Here is an example of the generated graph: enter image description here

edited Jul 7, 2015 at 19:26

answered Jul 7, 2015 at 18:35

Zythyr

1,2425 gold badges21 silver badges36 bronze badges

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

Comments

maxymoo · Accepted Answer · 2015-07-07 01:57:33Z

-1

You're one the right track, but you want merge rather than concat. Try this:

DF = pd.merge(df1,df2,on=['Genre','City'])
DF.Groupby([['Genre','City']]).sum().unstack().plot(kind = 'bar')

answered Jul 7, 2015 at 1:57

maxymoo

36.7k12 gold badges97 silver badges121 bronze badges

1 Comment

Zythyr Over a year ago

This solution doesn't work for me. I need to groupby only Genre or City; not both. On my bar graph, I want to two bars for each genre: one bar for representing data set 1 and the other bar representing data set 2.

Collectives™ on Stack Overflow

How to plot two DataFrame on same graph for comparison

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related