Get total of Pandas column
<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>