On adult.csv data set: on each one of the 4 groups defined by sex and income values, calculate total number of rows and average age and write results to a CSV file; on each one of the 4 groups defined by sex and income values, calculate the average of all numerical columns; on full input table count: a. rows with missing values in column occupation; b. all rows in column occupation; c. rows with no missing value in column occupation; d. all rows in another column (i.e. marital-status). Notice that this number should be the same as the number in 2.
EXAMPLES Server: 02_ETL_Data_Manipulation/02_Aggregations/08_More_GroupBy_Examples02_ETL_Data_Manipulation/02_Aggregations/08_More_GroupBy_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