<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>Area Code</th>
      <th>State</th>
      <th>Market</th>
      <th>Market Size</th>
      <th>Profit</th>
      <th>Margin</th>
      <th>Sales</th>
      <th>COGS</th>
      <th>Total Expenses</th>
      <th>Marketing</th>
      <th>Inventory</th>
      <th>Budget Profit</th>
      <th>Budget COGS</th>
      <th>Budget Margin</th>
      <th>Budget Sales</th>
      <th>ProductId</th>
      <th>Date</th>
      <th>Product Type</th>
      <th>Product</th>
      <th>Type</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>203</td>
      <td>Connecticut</td>
      <td>East</td>
      <td>Small Market</td>
      <td>75</td>
      <td>NaN</td>
      <td>225</td>
      <td>90</td>
      <td>60</td>
      <td>29</td>
      <td>1148</td>
      <td>90</td>
      <td>80</td>
      <td>130</td>
      <td>210</td>
      <td>2</td>
      <td>7/1/10</td>
      <td>Coffee</td>
      <td>Columbian</td>
      <td>Regular</td>
    </tr>
    <tr>
      <th>1</th>
      <td>203</td>
      <td>Connecticut</td>
      <td>East</td>
      <td>Small Market</td>
      <td>122</td>
      <td>NaN</td>
      <td>325</td>
      <td>130</td>
      <td>73</td>
      <td>42</td>
      <td>1134</td>
      <td>130</td>
      <td>110</td>
      <td>180</td>
      <td>290</td>
      <td>2</td>
      <td>11/1/10</td>
      <td>Coffee</td>
      <td>Columbian</td>
      <td>Regular</td>
    </tr>
    <tr>
      <th>2</th>
      <td>203</td>
      <td>Connecticut</td>
      <td>East</td>
      <td>Small Market</td>
      <td>105</td>
      <td>NaN</td>
      <td>289</td>
      <td>115</td>
      <td>69</td>
      <td>37</td>
      <td>1166</td>
      <td>110</td>
      <td>100</td>
      <td>160</td>
      <td>260</td>
      <td>2</td>
      <td>12/1/10</td>
      <td>Coffee</td>
      <td>Columbian</td>
      <td>Regular</td>
    </tr>
    <tr>
      <th>3</th>
      <td>203</td>
      <td>Connecticut</td>
      <td>East</td>
      <td>Small Market</td>
      <td>104</td>
      <td>NaN</td>
      <td>223</td>
      <td>90</td>
      <td>56</td>
      <td>29</td>
      <td>1148</td>
      <td>90</td>
      <td>80</td>
      <td>130</td>
      <td>210</td>
      <td>2</td>
      <td>7/1/11</td>
      <td>Coffee</td>
      <td>Columbian</td>
      <td>Regular</td>
    </tr>
    <tr>
      <th>4</th>
      <td>203</td>
      <td>Connecticut</td>
      <td>East</td>
      <td>Small Market</td>
      <td>104</td>
      <td>NaN</td>
      <td>223</td>
      <td>90</td>
      <td>56</td>
      <td>29</td>
      <td>1139</td>
      <td>90</td>
      <td>80</td>
      <td>130</td>
      <td>210</td>
      <td>2</td>
      <td>8/1/11</td>
      <td>Coffee</td>
      <td>Columbian</td>
      <td>Regular</td>
    </tr>
  </tbody>
</table>
</div>

   Area Code        State Market   Market Size  Profit  Margin  Sales  COGS  \
0        203  Connecticut   East  Small Market      75     NaN    225    90   
1        203  Connecticut   East  Small Market     122     NaN    325   130   
2        203  Connecticut   East  Small Market     105     NaN    289   115   
3        203  Connecticut   East  Small Market     104     NaN    223    90   
4        203  Connecticut   East  Small Market     104     NaN    223    90   

   Total Expenses  Marketing  Inventory  Budget Profit  Budget COGS  \
0              60         29       1148             90           80   
1              73         42       1134            130          110   
2              69         37       1166            110          100   
3              56         29       1148             90           80   
4              56         29       1139             90           80   

   Budget Margin  Budget Sales  ProductId     Date Product Type    Product  \
0            130           210          2   7/1/10       Coffee  Columbian   
1            180           290          2  11/1/10       Coffee  Columbian   
2            160           260          2  12/1/10       Coffee  Columbian   
3            130           210          2   7/1/11       Coffee  Columbian   
4            130           210          2   8/1/11       Coffee  Columbian   

      Type  
0  Regular  
1  Regular  
2  Regular  
3  Regular  
4  Regular  

Creating a Bar Chart for Total Profit by State

total profit by state bar chart

attached