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
Output DataFrame: rowsCount = 6, columnsCount = 6
city | total | adults | median age | min age | oldest |
---|
| | | | | firstName | lastName |
---|
London | 1 | 0 | 15.0 | 15 | Alice | Cooper |
Dubai | 1 | 1 | 45.0 | 45 | Bob | Dylan |
Moscow | 2 | 2 | 25.0 | 20 | Charlie | Byrd |
Milan | 1 | 1 | 40.0 | 40 | Charlie | Chaplin |
Tokyo | 1 | 1 | 30.0 | 30 | Bob | Marley |
null | 1 | 1 | 20.0 | 20 | Alice | Wolf |