title: Get total of Pandas column
body: <p>I have a Pandas data frame, as shown below, with multiple columns and would like to get the total of column, <code>MyColumn</code>.</p>
  <p><code>print df</code></p>
  <pre><code>           X           MyColumn      Y              Z   
  0          A           84         13.0           69.0   
  1          B           76         77.0          127.0   
  2          C           28         69.0           16.0   
  3          D           28         28.0           31.0   
  4          E           19         20.0           85.0   
  5          F           84        193.0           70.0   
  </code></pre>
  <hr />
  <p><em><strong>My attempt</strong></em>:</p>
  <p>I have attempted to get the sum of the column using <code>groupby</code> and <code>.sum()</code>:</p>
  <pre><code>Total = df.groupby['MyColumn'].sum()
  
  print Total
  </code></pre>
  <p>This causes  the following error:</p>
  <pre><code>TypeError: 'instancemethod' object has no attribute '__getitem__'
  </code></pre>
  <hr />
  <p><em><strong>Expected Output</strong></em></p>
  <p>I'd have expected the output to be as follows:</p>
  <pre><code>319
  </code></pre>
  <p>Or alternatively, I would like <code>df</code> to be edited with a new row entitled <code>TOTAL</code> containing the total:</p>
  <pre><code>           X           MyColumn      Y              Z   
  0          A           84         13.0           69.0   
  1          B           76         77.0          127.0   
  2          C           28         69.0           16.0   
  3          D           28         28.0           31.0   
  4          E           19         20.0           85.0   
  5          F           84        193.0           70.0   
  TOTAL                  319
  </code></pre>