Icon

03 Bringing Things Together

Task 1: GroupBy Task 2: Pivoting Task 3: Joiner Note: I have used adult.csv and adult_income.xlsx from the lab data to matchthe exercise.In the first Joiner, I have joined the two table by gender/sex (it takes toomuch time to load)In the second Joiner, I have joined by ID. The results might not make sensebecause the datasets (provided on Canvas and from the online lab) aredifferent and hard to join. Task 4: Concatenate Table: senior citizen as a groupand gender as a pivotCalculate:number of dependents in groupsTable: senior citizen as a group and gender as a pivotfind the most widespread InternetService providerRead dataadult_income.xlsxtotal number of rows and average tenure by gendermodes of all string columnsnumber of missing values in InternetService columnnumber of rows: InternetService, DeviceProtection, WA_Fn-UseC_-Telco-Customer-Churn.csvWA_Fn-UseC_-Telco-Customer-Churn.csvInner join by IDInner join by IDWA_Fn-UseC_-Telco-Customer-Churn.csvadult.csvWA_Fn-UseC_-Telco-Customer-Churn.csvadult.csvConcatenated both datasets Pivoting Pivoting Excel Reader GroupBy GroupBy GroupBy CSV Reader CSV Reader Joiner Joiner CSV Reader CSV Reader CSV Reader CSV Reader Concatenate Task 1: GroupBy Task 2: Pivoting Task 3: Joiner Note: I have used adult.csv and adult_income.xlsx from the lab data to matchthe exercise.In the first Joiner, I have joined the two table by gender/sex (it takes toomuch time to load)In the second Joiner, I have joined by ID. The results might not make sensebecause the datasets (provided on Canvas and from the online lab) aredifferent and hard to join. Task 4: Concatenate Table: senior citizen as a groupand gender as a pivotCalculate:number of dependents in groupsTable: senior citizen as a group and gender as a pivotfind the most widespread InternetService providerRead dataadult_income.xlsxtotal number of rows and average tenure by gendermodes of all string columnsnumber of missing values in InternetService columnnumber of rows: InternetService, DeviceProtection, WA_Fn-UseC_-Telco-Customer-Churn.csvWA_Fn-UseC_-Telco-Customer-Churn.csvInner join by IDInner join by IDWA_Fn-UseC_-Telco-Customer-Churn.csvadult.csvWA_Fn-UseC_-Telco-Customer-Churn.csvadult.csvConcatenated both datasets Pivoting Pivoting Excel Reader GroupBy GroupBy GroupBy CSV Reader CSV Reader Joiner Joiner CSV Reader CSV Reader CSV Reader CSV Reader Concatenate

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: Rena
Created at: 2023-02-23
On NodePit since: 2023-02-26
Last update: 2024-05-01
Created with KNIME version: v4.7.0

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

Try NodePit Runner!