subplot by group in python pandas

Question

I wanna make subplots for the following data. I averaged and grouped together. I wanna make subpolts by country for x-axis resource and y-axis average.

country       resource     average
india         water         76
india         soil          45
india         tree          60
US            water         45
US            soil          70
US            tree          85
Germany       water         76
Germany       soil          65
Germany       water         56

Grouped = df.groupby(['country','resource'])['TTR in minutes'].agg({'average': 'mean'}).reset_index()

I tried but couldn't plot in subplots

piRSquared · Accepted Answer · 2018-03-15 18:11:44Z

3

g = df.groupby('country')

fig, axes = plt.subplots(g.ngroups, sharex=True, figsize=(8, 6))

for i, (country, d) in enumerate(g):
    ax = d.plot.bar(x='resource', y='average', ax=axes[i], title=country)
    ax.legend().remove()

fig.tight_layout()

answered Mar 15, 2018 at 18:11

piRSquared

296k68 gold badges509 silver badges654 bronze badges

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

Collectives™ on Stack Overflow

subplot by group in python pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related