Bar plot with groupby

Question

My categorical variable case_satus takes on four unique values. I have data from 2014 to 2016. I would like to plot the distribution of case_status grouped by year. I try to this using:

df.groupby('year').case_status.value_counts().plot.barh() 

And I get the following plot:

What I would like to have is a nicer represenation. For example where I have one color for each year, and all the "DENIED" would stand next to each other.

I think it can be achieved since the groupby object is a multi-index, but I don't understand it well enough to create the plot I want.

---

The solution is:

df.groupby('year').case_status.value_counts().unstack(0).plot.barh() 

and results in

Answer 1

I think you need add unstack for DataFrame:

df.groupby('year').case_status.value_counts().unstack().plot.barh() 

Also is possible change level:

df.groupby('year').case_status.value_counts().unstack(0).plot.barh()