Two dataframe boxplots on one graph python

Question

I'm trying to construct two boxplots on one graph in python:

ax = df.boxplot(column = ['price'], by = ['urban'],meanline=True, showmeans=True, showcaps=True, 
            showbox=True, showfliers=False, return_type='axes')
df1.boxplot(column = ['price'], by = ['urban'], meanline=True, showmeans=True, showcaps=True, 
           showbox=True, showfliers=False, ax=ax)

These boxplots are built on the same graph, but they overlap each other. Whereas in df 'urban' is always equal to 1 (and this works correctly on a separate boxplot) and in df1 it is always 0. On the general graph they both are shown as 0. How can I fix it?

Does this answer your question? Consider upvoting if it does. stackoverflow.com/questions/63512119/… — Arsik36
– Arsik36, Commented Oct 10, 2020 at 18:36

StupidWolf · Accepted Answer · 2020-10-10 18:43:11Z

1

You can concatenate the data.frames and plot:

df = pd.DataFrame({'price':np.random.uniform(0,100,100), 'urban':np.repeat(0,100)})
df1 = pd.DataFrame({'price':np.random.uniform(0,100,100), 'urban':np.repeat(1,100)})

pd.concat([df,df1]).boxplot(column='price',by='urban')

answered Oct 10, 2020 at 18:43

StupidWolf

47.1k17 gold badges50 silver badges81 bronze badges

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

3 Comments

Igor Igor Over a year ago

Thank you! It is working really nice, but can I somehow change the color of these boxplots separately? I have tried a list with colors but nothing works.

StupidWolf Over a year ago

It's not so straight forward with pd.boxplot.. see stackoverflow.com/questions/50963960/…

StupidWolf Over a year ago

you can use seaborn ; sns.boxplot(data=pd.concat([df,df1]),y='price',x='urban',hue='urban')

Collectives™ on Stack Overflow

Two dataframe boxplots on one graph python

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related