Icon

02 Data Cleaning

Task 1: Filter rows Task 1: Filter Columns Manipulate String Mathematical expression airlines.csvairplanes.csvairports.csvroutes.csvCountry filtered - United StatesName starts with "a"Altitude > 1000Missing values filteredairlines.csvairplanes.csvairports.csvroutes.csvAirline ID - num typeName filtered outColumns w/ "C" Columns with Stringsairlines.csvReplaced :United States with "USA"Replaced "/" with "-" in Time Zone columnairports.csvAdded new column:Airport name with CityDifference in Latitude and Altitude; converted to intairports.csvDisplayed High Longitude value (>= 130) CSV Reader CSV Reader CSV Reader CSV Reader Row Filter Row Filter Row Filter Row Filter CSV Reader CSV Reader CSV Reader CSV Reader Column Filter Column Filter Column Filter Column Filter CSV Reader String Manipulation String Manipulation CSV Reader String Manipulation Math Formula CSV Reader Rule Engine Task 1: Filter rows Task 1: Filter Columns Manipulate String Mathematical expression airlines.csvairplanes.csvairports.csvroutes.csvCountry filtered - United StatesName starts with "a"Altitude > 1000Missing values filteredairlines.csvairplanes.csvairports.csvroutes.csvAirline ID - num typeName filtered outColumns w/ "C" Columns with Stringsairlines.csvReplaced :United States with "USA"Replaced "/" with "-" in Time Zone columnairports.csvAdded new column:Airport name with CityDifference in Latitude and Altitude; converted to intairports.csvDisplayed High Longitude value (>= 130) CSV Reader CSV Reader CSV Reader CSV Reader Row Filter Row Filter Row Filter Row Filter CSV Reader CSV Reader CSV Reader CSV Reader Column Filter Column Filter Column Filter Column Filter CSV Reader String Manipulation String Manipulation CSV Reader String Manipulation Math Formula CSV Reader Rule Engine

Nodes

Extensions

Links