Icon

ciullajn Data Cleaning Custom Data

Task 1: Filter rows1. Read the airlines, airports, and airplanes data 2. Filter the country to only USA3. Filter the airports timezone to 0 or above4. Filter ICAO code to AT only John CiullaExercise 2 Task 2: Filter columns1. NO DATABASE PROVIDED. Used csv instead2. Exclude the AirlineID column- Manually- By including only string columns Task 3: Manipulate strings1. Read the airports.csv file2. Make OurAirports in Source to only Ours3. Extract the first three letters of the country into their own column Task 4: Evaluate mathematical expressions and apply rules1. Read the airports data2. Create a new column "Lat-Long" by subtracting the Lat and Long values3. Convert new column to percentage4. Create a categorical column with two values "positive or negative" based on whether thechange is positive or negative airlines.csvairplanes.csvairports.csvUSA onlyAT onlyTimezone 0 or aboveManualType Selectairlines.csvOursFirst 3Same as Aboveairports.csvairports.csvSubtractPercentagePos/Neg CSV Reader CSV Reader CSV Reader Row Filter Row Filter Row Filter Column Filter Column Filter CSV Reader String Manipulation String Manipulation Column Expressions CSV Reader CSV Reader Math Formula Math Formula Rule Engine Task 1: Filter rows1. Read the airlines, airports, and airplanes data 2. Filter the country to only USA3. Filter the airports timezone to 0 or above4. Filter ICAO code to AT only John CiullaExercise 2 Task 2: Filter columns1. NO DATABASE PROVIDED. Used csv instead2. Exclude the AirlineID column- Manually- By including only string columns Task 3: Manipulate strings1. Read the airports.csv file2. Make OurAirports in Source to only Ours3. Extract the first three letters of the country into their own column Task 4: Evaluate mathematical expressions and apply rules1. Read the airports data2. Create a new column "Lat-Long" by subtracting the Lat and Long values3. Convert new column to percentage4. Create a categorical column with two values "positive or negative" based on whether thechange is positive or negative airlines.csvairplanes.csvairports.csvUSA onlyAT onlyTimezone 0 or aboveManualType Selectairlines.csvOursFirst 3Same as Aboveairports.csvairports.csvSubtractPercentagePos/Neg CSV Reader CSV Reader CSV Reader Row Filter Row Filter Row Filter Column Filter Column Filter CSV Reader String Manipulation String Manipulation Column Expressions CSV Reader CSV Reader Math Formula Math Formula Rule Engine

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: John
Created at: 2023-05-16
On NodePit since: 2023-05-17
Last update: 2024-04-27
Created with KNIME version: v4.7.2

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

Try NodePit Runner!