Icon

Demo Exercises Part 1

01 Data Access - Exercise

This workflow shows a hands-on exercise in the L1-DW KNIME Analytics Platform for Data Wranglers: Basics course


Exercise 1: Reading data from file1. Read the following files, available in the data folder, using the appropriate reader nodes2. Change the file paths to workflow relative paths Exercise 2: Filters, String manipulation & Column expression, Math formula, & RuleEngine1. Filter the airlines based in United States2. Manually exclude the latitude and longitude columns, then do it by type3. Filter the destination airport ID on routes to be at least 4000. Exclude missing values.4. Find the column mean of destination airport ID on routes using the math formula node5. Change United States in airlines to USA with string manipulation and columnexpressions6. Replace the following with a single rule engine, then count names by country.United Kingdom = UKUnited States = USSouth Africa = SAUnited Arab Emirates = UAEDominican Republic = DR airplanes.csvairports.csvroutes.csvairlines.csvairlines.csvManually exclude long and latAirlines in the USairports.csvroutes.csvlesser bound 4000Destination Airport ID to integerType exclude long and latUnited States to USAUnited States to USAColumn mean of Destination Airport IDTask 5Task 5 CSV Reader CSV Reader CSV Reader CSV Reader CSV Reader Column Filter Row Filter CSV Reader CSV Reader Row Filter String To Number Column Filter String Manipulation Column Expressions Math Formula Rule Engine GroupBy Exercise 1: Reading data from file1. Read the following files, available in the data folder, using the appropriate reader nodes2. Change the file paths to workflow relative paths Exercise 2: Filters, String manipulation & Column expression, Math formula, & RuleEngine1. Filter the airlines based in United States2. Manually exclude the latitude and longitude columns, then do it by type3. Filter the destination airport ID on routes to be at least 4000. Exclude missing values.4. Find the column mean of destination airport ID on routes using the math formula node5. Change United States in airlines to USA with string manipulation and columnexpressions6. Replace the following with a single rule engine, then count names by country.United Kingdom = UKUnited States = USSouth Africa = SAUnited Arab Emirates = UAEDominican Republic = DR airplanes.csvairports.csvroutes.csvairlines.csvairlines.csvManually exclude long and latAirlines in the USairports.csvroutes.csvlesser bound 4000Destination Airport ID to integerType exclude long and latUnited States to USAUnited States to USAColumn mean of Destination Airport IDTask 5Task 5 CSV Reader CSV Reader CSV Reader CSV Reader CSV Reader Column Filter Row Filter CSV Reader CSV Reader Row Filter String To Number Column Filter String Manipulation Column Expressions Math Formula Rule Engine GroupBy

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: 2023-05-21
Last update: 2024-11-21
Created with KNIME version: v4.7.2
Tags: educationl1-dw

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

Try NodePit Runner!