title: Python Table Formatting
body: <p>I'm trying to subtotal a column from a table and format the sum numbers using Python in Spyder.</p>
  <p>I have this example table in .csv file format:</p>
  <p><img src="https://i.stack.imgur.com/3sPYf.jpg" alt="enter image description here" /></p>
  <p>I would like to subtotal Column5 at each change in Column1.
  Then format the sum numbers to whole numbers and show the result as a new table showing Column1 and Columb5 sum values only.</p>
  <p>I got as far as using</p>
  <pre><code>pd.read_csv  #to get the file and  
  .groupby(&quot;Column1&quot;)[&quot;Column5&quot;].sum()   #to do the subtotal
  </code></pre>
  <p>but I'm not sure how to format the result values to show as whole numbers and I'm not sure how to print this as a table.</p>
  <p>This is the end result I'd like:</p>
  <p><img src="https://i.stack.imgur.com/lYQ9o.jpg" alt="enter image description here" /></p>
  <p>How can I achieve that?</p>