title: Is there an equivalent of SQL GROUP BY ROLLUP in Python pandas?
body: <p><a href="http://oracle-base.com/articles/misc/rollup-cube-grouping-functions-and-grouping-sets.php" rel="nofollow">Here</a> is how it works in Oracle. I'm looking for a neat equivalent in pandas, preferably integrated with the rendering of the DataFrame to python notebook. The gist of GROUP BY ROLLUP is that if you group by multiple columns you will also see aggregates as if grouped by subsets of these columns.</p>