title: Format / Suppress Scientific Notation from Pandas Aggregation Results
body: <p>How can one modify the format for the output from a groupby operation in pandas that produces scientific notation for very large numbers? </p>
  
  <p>I know how to do string formatting in python but I'm at a loss when it comes to applying it here. </p>
  
  <pre><code>df1.groupby('dept')['data1'].sum()
  
  dept
  value1       1.192433e+08
  value2       1.293066e+08
  value3       1.077142e+08
  </code></pre>
  
  <p>This suppresses the scientific notation if I convert to string but now I'm just wondering how to string format and add decimals. </p>
  
  <pre><code>sum_sales_dept.astype(str)
  </code></pre>