Multi-index dataframe with summarising rows
<p>I am trying to do a multilevel index dataframe looking like a pivot table with rows at a higher level showing aggregated numbers. Something like the output below</p>

<pre><code>                   Points
Total                  10 
      Girls             3 
           TeamA        1
           TeamB        2
      Boys              7 
           TeamA        3
           TeamB        4
</code></pre>

<p>If this can be done straight away with the dataframe constructor by passing in the values and the index that would be even better. Is this possible?</p>