Icon

14_​Pivoting

14_Pivoting
Exercise Pivoting1) Read data adult_binned.csv available in the "data" folder2) Calculate the number of people in groups according to their work class and age bins- What is the most common combination of age bin and work class?- How many people belong to this group?3) Add income to the grouping columns, and take a look at the income class of the people inthe biggest group you calculated in the previous step. Do most of them earn more or less than50K per year?4) Remove “income” from the grouping columns again and change the aggregation method- What is the most widespread education level according to age bin and work class?- In which work classes is the most widespread education level of the youngest bin higherthan the education of the oldest bin? Exercise Pivoting1) Read data adult_binned.csv available in the "data" folder2) Calculate the number of people in groups according to their work class and age bins- What is the most common combination of age bin and work class?- How many people belong to this group?3) Add income to the grouping columns, and take a look at the income class of the people inthe biggest group you calculated in the previous step. Do most of them earn more or less than50K per year?4) Remove “income” from the grouping columns again and change the aggregation method- What is the most widespread education level according to age bin and work class?- In which work classes is the most widespread education level of the youngest bin higherthan the education of the oldest bin?

Nodes

  • No nodes found

Extensions

  • No modules found

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Maarit Laukkanen
Created at: 2020-04-20
On NodePit since: 2020-08-06
Last update: 2024-11-21
Created with KNIME version: v4.1.2
Tags: e-learningaggregationgrouppivoteducation

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!