df.pivotCounts { city }

Input DataFrame: rowsCount = 7, columnsCount = 5

Output DataFrame: rowsCount = 7, columnsCount = 5

df.pivot { city }.groupByOther().count()

Input DataFrame: rowsCount = 7, columnsCount = 5

Step 1: Pivot

Step 2: PivotGroupBy

Output DataFrame: rowsCount = 7, columnsCount = 5

df.groupBy { name }.pivotCounts { city }

Input DataFrame: rowsCount = 7, columnsCount = 5

Step 1: GroupBy

Output DataFrame: rowsCount = 7, columnsCount = 2

df.groupBy { name }.pivot { city }.count()

Input DataFrame: rowsCount = 7, columnsCount = 5

Step 1: GroupBy

Step 2: PivotGroupBy

Output DataFrame: rowsCount = 7, columnsCount = 2

df.groupBy { name }.aggregate { pivotCounts { city } }

Input DataFrame: rowsCount = 7, columnsCount = 5

Step 1: GroupBy

Output DataFrame: rowsCount = 7, columnsCount = 2