stacked barplot from dataframe

stacked_barplot.py

import pandas as pd


df = pd.DataFrame({'name': ['Store A', 'Store B', 'Store C', 'Store D']
                   'district': ['I', "II", "I", "III"],
                   "category": [X, X, Y, Z]
                   }
                  )

district_category_pivot_table = df.pivot_table('name', 'district', 'category', aggfunc='count')
district_category_pivot_table['total'] = district_category_pivot_table.sum(1)
district_category_pivot_table\
  .sort_values(by='total', ascending=True)\
  .drop(columns=['total'])\
  .plot.barh(stacked=True, xlabel='', ylabel='', grid=True,
             title='Number of name by district and category');