title: Difficulty grouping barchart using Python, Pandas and Matplotlib
body: <p>I am having difficulty getting plot.bar to group the bars together the way I have them grouped in the dataframe.  The dataframe returns the grouped data correctly, however, the bar graph is providing a separate bar for every line int he dataframe.  Ideally, everything in my code below should group 3-6 bars together for each department (Dept X should have bars grouped together for each type, then count of true/false as the Y axis).</p>
  
  <p>Dataframe:</p>
  
  <pre><code>dname             Type  purchased
  Dept X       0     False        141
                     True         270
               1     False       2020
                     True        2604
               2     False       2023
                     True        1047
  </code></pre>
  
  <p>Code:</p>
  
  <pre><code>import psycopg2
  import pandas as pd
  import numpy as np
  import matplotlib.pyplot as plt
  
   ##connection and query data removed
  
  df = pd.merge(df_departments[["id", "dname"]], df_widgets[["department", "widgetid", "purchased","Type"]], how='inner', left_on='id', right_on='department')
  df.set_index(['dname'], inplace=True)
  dx=df.groupby(['dname', 'Type','purchased'])['widgetid'].size()
  dx.plot.bar(x='dname', y='widgetid', rot=90)
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/PyrWf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PyrWf.png" alt="output from dataframe"></a></p>