On adult.csv data set: 1. calculate the average age and number of rows for the 4 groups (sex, income) and join the corresponding 2 values to each row in the group; 2. extract people with age between 20 and 40 and working in a work group starting with "S" and people with age between 40 and 60 and working in the Private sector (workclass starts with "P"). Put both groups in a single data table.
EXAMPLES Server: 02_ETL_Data_Manipulation/03_Joining_and_Concatenating/03_JoinConcatenate_Examples02_ETL_Data_Manipulation/03_Joining_and_Concatenating/03_JoinConcatenate_Examples*
Download a zip-archive
* Find more about the Examples Server here.
The link will open the workflow directly in KNIME Analytics Platform (requirements: Windows; KNIME Analytics Platform must be installed with the Installer version 3.2.0 or higher). In other cases, please use the link to a zip-archive or open the provided path manually