Make a pivot table showing mean age of passengers:

Mean age per class and sex:

Show margins with the mean age for group subsets:

Take tabular data about sales:

Construct a pivot table showing number of product types per region and sector:

Take a table of data about penguins in the Palmer Archipelago:

Construct a pivot table specifying the output row keys and column keys by multiple input columns:

Show the number that lived and died for the Titanic:

Show group aggregate summaries:

Make a pivot table showing the percent survival for the Titanic:

Percent survived per class and per sex:

Show margins with the survival rate for group subsets:

Perform a PivotTable operation with a given list of aggregation functions:

This is equivalent to using AggregateRows with the same aggregations, followed by PivotToColumns to restructure the result:

The group aggregate summaries can be obtained as follows:

Compare to the group aggregation row and columns of this result:

Pivot tables have row keys:

Extract the list of row keys:

Use RowKey to access group aggregate values: