Using the adult.csv data set: on each one of the 4 groups defined by sex and income values, calculate the total number of rows and average age and write the 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.
Workflow
Workflow Demonstrating GroupBy Examples
Used extensions & nodes
Created with KNIME Analytics Platform version 4.1.1
- Go to item
- Go to item
- Go to item
Loading deployments
Loading ad hoc jobs
Legal
By using or downloading the workflow, you agree to our terms and conditions.