Icon

30 Days of KNIME - Flights Workflow

Read in fileExplore dataShapeMissingMin, max, avg, etcRemove columns witn 10%+ missingvaluesRemove stringrows with missingvaluesOnly incomingFL FlightsOnly flightsin 21st centuryDrop columnsCreate flight codeConvert date stringto time variable typeExtract time variableparts of interestWeekend flagTrue/false variant dictionaryMake cancelled column values consistentMake diverted column values consistentExluding DivertedflightsExcluding DivertedColumnsNot cancelledCancelledGet rid of rowswith missing valuesfor non cancelled flightsPut the databack togetherParse out arilinecode from nameDrop ColumnsReorder ColumnsCount of flightsper yearper airlineNode 77Aggregate fightsinto cancelled, not cancelledby airlineSub missingwith 0Proportion cancelledRemove city and state from airport nameRemove "miles" fromdistanceConvertdistance to longConvert string time variablesto Hmm (time) variableConvert timevariables to stringPad hour with 0Flight arrival hourCancelled/nonecancelled by hour? to 0Cancelled/Non-cancelled flights by hourNode 100Under SamplingOversampling by creationGet rid ofoutliersNon-cancelledflights onlyGroupbyAirlineNon cancelledflights onlyCluster airlinesby avg distanceand mode hourAssign colorto clusterDistance andMode arrival hourby clusterInteractive tableview of clusterSelect ColumnsConvert Numbrersto Strings70/20 Train/Test SplitFile Reader Data Explorer Missing ValueColumn Filter Missing Value Row Filter Row Filter Column Filter Column Expressions String to Date&Time Extract Date&TimeFields Rule Engine Table Creator Cell Replacer Cell Replacer Row Filter Column Filter Row Splitter Missing Value Concatenate Cell Splitter Column Filter Column Resorter GroupBy Column Rename Pivoting Missing Value Column Rename Math Formula String Manipulation(Multi Column) String Manipulation String To Number String to Date&Time Number To String String Manipulation(Multi Column) Extract Date&TimeFields Pivoting Missing Value Line Plot Bar Chart Equal Size Sampling SMOTE Numeric Outliers Row Filter GroupBy Row Filter k-Means Color Manager Scatter Plot Table View Column Filter Number To String Partitioning Read in fileExplore dataShapeMissingMin, max, avg, etcRemove columns witn 10%+ missingvaluesRemove stringrows with missingvaluesOnly incomingFL FlightsOnly flightsin 21st centuryDrop columnsCreate flight codeConvert date stringto time variable typeExtract time variableparts of interestWeekend flagTrue/false variant dictionaryMake cancelled column values consistentMake diverted column values consistentExluding DivertedflightsExcluding DivertedColumnsNot cancelledCancelledGet rid of rowswith missing valuesfor non cancelled flightsPut the databack togetherParse out arilinecode from nameDrop ColumnsReorder ColumnsCount of flightsper yearper airlineNode 77Aggregate fightsinto cancelled, not cancelledby airlineSub missingwith 0Proportion cancelledRemove city and state from airport nameRemove "miles" fromdistanceConvertdistance to longConvert string time variablesto Hmm (time) variableConvert timevariables to stringPad hour with 0Flight arrival hourCancelled/nonecancelled by hour? to 0Cancelled/Non-cancelled flights by hourNode 100Under SamplingOversampling by creationGet rid ofoutliersNon-cancelledflights onlyGroupbyAirlineNon cancelledflights onlyCluster airlinesby avg distanceand mode hourAssign colorto clusterDistance andMode arrival hourby clusterInteractive tableview of clusterSelect ColumnsConvert Numbrersto Strings70/20 Train/Test SplitFile Reader Data Explorer Missing ValueColumn Filter Missing Value Row Filter Row Filter Column Filter Column Expressions String to Date&Time Extract Date&TimeFields Rule Engine Table Creator Cell Replacer Cell Replacer Row Filter Column Filter Row Splitter Missing Value Concatenate Cell Splitter Column Filter Column Resorter GroupBy Column Rename Pivoting Missing Value Column Rename Math Formula String Manipulation(Multi Column) String Manipulation String To Number String to Date&Time Number To String String Manipulation(Multi Column) Extract Date&TimeFields Pivoting Missing Value Line Plot Bar Chart Equal Size Sampling SMOTE Numeric Outliers Row Filter GroupBy Row Filter k-Means Color Manager Scatter Plot Table View Column Filter Number To String Partitioning

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: sntra
Created at: 2021-11-07
On NodePit since: 2021-12-19
Last update: 2024-04-28
Created with KNIME version: v4.4.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!