summing up certain rows in a panda dataframe
<p>I have a pandas dataframe with 1000 rows and 10 columns. I am looking to aggregate rows 100-1000 and replace them with just one row where the indexvalue is '>100' and the column values are the sum of rows 100-1000 of each column. Any ideas on a simple way of doing this? Thanks in advance</p>

<p>Say I have the below</p>

<pre><code>     a    b    c
0    1    10   100
1    2    20   100
2    3    60   100
3    5    80   100
</code></pre>

<p>and I want it replaced with</p>

<pre><code>     a    b    c
0    1    10   100
1    2    20   100
&gt;1   8    140  200
</code></pre>