Icon

06 Aggregations

06 Aggregations
Exercise: GroupBy1) Read the telco-customer-churn.csv file by executing the CSV Reader node2) Calculate the total number of rows and average total cost by gender3) Calculate the modes of all numeric columns4) Calculate - the number of missing values in the gender column- the number of non-missing rows in the gender column- the number of rows in the gender column- the number of rows by option in the dependent column Notice that there are no missing values and the second and third aggregations should provide the same numbers! Exercise: Pivoting1) Read the telco-customer-churn.csv file by executing the CSV Reader node2) Calculate the number of people in groups according to their gender and internet service bin.3) Calculate the mean of monthly charges according to their phone and internet service. telco-customer-churn.csvtotal # of rowsand average total costby genderthe # of missing values, non-missing rows and # of rows in the gender columnand the # of rows by options in the dependent columnmodes of all numeric columnsthe number of people in groups according to their gender and internet service the mean of monthly charge in groups according to their phone and internet servicetelco-customer-churn.csv CSV Reader GroupBy GroupBy GroupBy Pivoting Pivoting CSV Reader Exercise: GroupBy1) Read the telco-customer-churn.csv file by executing the CSV Reader node2) Calculate the total number of rows and average total cost by gender3) Calculate the modes of all numeric columns4) Calculate - the number of missing values in the gender column- the number of non-missing rows in the gender column- the number of rows in the gender column- the number of rows by option in the dependent column Notice that there are no missing values and the second and third aggregations should provide the same numbers! Exercise: Pivoting1) Read the telco-customer-churn.csv file by executing the CSV Reader node2) Calculate the number of people in groups according to their gender and internet service bin.3) Calculate the mean of monthly charges according to their phone and internet service. telco-customer-churn.csvtotal # of rowsand average total costby genderthe # of missing values, non-missing rows and # of rows in the gender columnand the # of rows by options in the dependent columnmodes of all numeric columnsthe number of people in groups according to their gender and internet service the mean of monthly charge in groups according to their phone and internet servicetelco-customer-churn.csv CSV Reader GroupBy GroupBy GroupBy Pivoting Pivoting CSV Reader

Nodes

Extensions

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: 2022-02-26
Last update: 2024-11-18
Created with KNIME version: v4.5.1
Tags: aggregationgrouppivotgroupby

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

Try NodePit Runner!