df.groupBy { city }.count()

Input DataFrame: rowsCount = 7, columnsCount = 5

name		age	city	weight	isHappy
firstName	lastName
Alice	Cooper	15	London	54	true
Bob	Dylan	45	Dubai	87	true
Charlie	Daniels	20	Moscow	null	false
Charlie	Chaplin	40	Milan	null	true
Bob	Marley	30	Tokyo	68	true
Alice	Wolf	20	null	55	false
Charlie	Byrd	30	Moscow	90	true

Step 1: GroupBy

city	group
London	DataFrame 1 x 5
Dubai	DataFrame 1 x 5
Moscow	DataFrame 2 x 5
Milan	DataFrame 1 x 5
Tokyo	DataFrame 1 x 5
null	DataFrame 1 x 5

Output DataFrame: rowsCount = 6, columnsCount = 2

city	count
London	1
Dubai	1
Moscow	2
Milan	1
Tokyo	1
null	1

df.pivot { city }.count { age > 18 }

Input DataFrame: rowsCount = 7, columnsCount = 5

name		age	city	weight	isHappy
firstName	lastName
Alice	Cooper	15	London	54	true
Bob	Dylan	45	Dubai	87	true
Charlie	Daniels	20	Moscow	null	false
Charlie	Chaplin	40	Milan	null	true
Bob	Marley	30	Tokyo	68	true
Alice	Wolf	20	null	55	false
Charlie	Byrd	30	Moscow	90	true

Step 1: Pivot

London	Dubai	Moscow	Milan	Tokyo	null
DataFrame 1 x 5	DataFrame 1 x 5	DataFrame 2 x 5	DataFrame 1 x 5	DataFrame 1 x 5	DataFrame 1 x 5

Output DataRow

London	Dubai	Moscow	Milan	Tokyo	null
0	1	2	1	1	1

df.pivot { name.firstName }.groupBy { name.lastName }.count()

Input DataFrame: rowsCount = 7, columnsCount = 5

name		age	city	weight	isHappy
firstName	lastName
Alice	Cooper	15	London	54	true
Bob	Dylan	45	Dubai	87	true
Charlie	Daniels	20	Moscow	null	false
Charlie	Chaplin	40	Milan	null	true
Bob	Marley	30	Tokyo	68	true
Alice	Wolf	20	null	55	false
Charlie	Byrd	30	Moscow	90	true

Step 1: Pivot

Alice	Bob	Charlie
DataFrame 2 x 5	DataFrame 2 x 5	DataFrame 3 x 5

Step 2: PivotGroupBy

lastName	name
	firstName
Cooper	{ Alice: DataFrame [1 x 5], B..., C... }
Dylan	{ Alice: DataFrame [0 x 0], B..., C... }
Daniels	{ Alice: DataFrame [0 x 0], B..., C... }
Chaplin	{ Alice: DataFrame [0 x 0], B..., C... }
Marley	{ Alice: DataFrame [0 x 0], B..., C... }
Wolf	{ Alice: DataFrame [1 x 5], B..., C... }
Byrd	{ Alice: DataFrame [0 x 0], B..., C... }

Output DataFrame: rowsCount = 7, columnsCount = 2

lastName	name
	firstName
Cooper	{ Alice: 1, Bob: 0, Charlie: 0 }
Dylan	{ Alice: 0, Bob: 1, Charlie: 0 }
Daniels	{ Alice: 0, Bob: 0, Charlie: 1 }
Chaplin	{ Alice: 0, Bob: 0, Charlie: 1 }
Marley	{ Alice: 0, Bob: 1, Charlie: 0 }
Wolf	{ Alice: 1, Bob: 0, Charlie: 0 }
Byrd	{ Alice: 0, Bob: 0, Charlie: 1 }