06 Aggregations - Solution

Solution to an exercise for data aggregation.

Calculate summary statistics for subgroups of data with the GroupBy and Pivoting nodes.

CHECK YOUR ANSWERS:

GroupBy:
a. The average age is 37 years for the women and 39 years for the men
b. Husband is the most common family relationship of the German people in the data
c. The number of rows in the data is 32549

Pivoting:
a. The most common combination of age bin and work class is <35 years and Private. 10936 people belong to this group.
b. The most widespread education level in the Private workclass is HS-grad

External resources

• The Pivoting Node
• The GroupBy Node: And how to use it
• What is Data Aggregation?