Icon

Filled Missings.knar

Feiertage Aufteilen in 2003-2013 und 2014-2023 wegenfehlender Bestellnummer in 2003-2013. Einlesen aller Mülldaten Todo:KUNNR ist im Moment rausgenommen, da 2012und 2013 fast komplett entfernt worden sind Calculate all Missing Dates from Main Data Tables Meta Data Analysis:How many missings were filled up? Amount of missings filled Auffüllen von MissingsFill up all missings with the same date of the next year. If the next year's date is a saturday, then use the next weekday, Cleanup Result of filling missings Finales Ergebnis FinalesErgebnisderMissings-Befüllung KUNNR = 0010002476LGORT = 0003BESTELLNR = 100005 oder 0000100005STORNO != XTonnageJahr Doubletten entfernenNode 112Node 122Node 123Node 124TagAlle (vorhandenen)Tage mit summierteGewichte2003-2018Lgort to INTFES_WaagenJoin Wiegedaten& Anlagenbased on LgortCreate month-daycolumnGet sum and countof net_weight for eachday over all yearsCalculate averageTurn to numberRemove decimalplacesAlle enthaltenen Tagevon 2003-2023All Missing DatesRemove double entriesfrom interval settingGet year, month, dayTurn int to doubleAverage valuesfor all missing datesAlle dates withoriginal and filled upvaluesFill all sundays with weight=0and all other missings with averageNode 291Get year, month, dayExtract DateUmformatieren für joinNode 2570Node 2572Node 2573Node 2574Create 365 lagsNode 2579Node 2581Node 2589Node 2590Node 2591Node 2594Node 2595Node 2596Node 2597Node 2598Node 2600Node 2603Node 26042019-2023Join all dataGet all HolidaysAdd column "isMissing"with value "true"for all missing datesJoin everythingAll non-missingsget "false" in columnisMissingFill missings with NEXT year'syear-month-weekdayRemoveholidays outsidetimeframeAdd columnisHoliday2014-20232003-2013LGORT = 0003STORNO != XNur SiedlungsabfälleNode 2651CleanupCleanupGet year, month, dayAll Missings,Sundays, andHolidaysGet year, month, dayFill up "false"for non-holidaysRemoveholidaysRemovemissingsMake missings,holidays = 0Remove SundaysBetter columnnamesCount how manyentries are leftRemove 0-weight entriesCount how manyentries are leftRemove 0-weight entriesAll missings +non missings(holidays unmarked)Node 2676Join for countRename forbetter usabilityTotal amount of missings filledRemove ? valuesRemove ? valuesAverage weightfor each year-month-weekDoubletten entfernenRemove unnecessarycolumnsBetter columnnamesSort by datesascendingALL dates withmissings filled upMake holidays = 0All missings (filled up)joined with all holidays (0)Removeholiday nameDoubletten entfernenFill missings with THIS year'syear-month-weekdayRow Splitter (Labs) Math Formula Extract Date&TimeFields DuplicateRow Filter String Manipulation SARIMA Learner SARIMA Predictor Numeric Scorer Joiner Line Plot AggregationGranularity GroupBy Excel Reader String To Number CSV Reader Joiner String Manipulation GroupBy Column Expressions String To Number String Manipulation Create Date&TimeRange Joiner DuplicateRow Filter Extract Date&TimeFields Math Formula Joiner Joiner Rule Engine Column Rename Extract Date&TimeFields String Manipulation String to Date&Time Deployment Loop Keras LSTM Layer Keras Input Layer Keras Dense Layer Keras NetworkLearner Lag Column Partitioning Column Aggregator Line Plot Numeric Scorer Column Filter AggregationGranularity AggregationGranularity Joiner RowID Sorter Row Filter Partitioning Joiner AggregationGranularity AggregationGranularity Joiner Numeric Outliers Excel Reader Joiner CSV Reader Column Expressions Joiner Rule Engine Python Script Row Filter Column Expressions Test Dashboard Row Filter Row Filter Row Splitter (Labs) Rule-basedRow Filter Joiner Column Filter Column Filter Extract Date&TimeFields Joiner Extract Date&TimeFields Rule Engine Row Filter Row Filter Rule Engine Row Filter Column Rename GroupBy Row Filter GroupBy Row Filter Joiner Column Rename Joiner Column Rename Python Script Missing Value Missing Value GroupBy DuplicateRow Filter Column Filter Column Rename Sorter RowID Rule Engine Joiner Column Filter DuplicateRow Filter Python Script Feiertage Aufteilen in 2003-2013 und 2014-2023 wegenfehlender Bestellnummer in 2003-2013. Einlesen aller Mülldaten Todo:KUNNR ist im Moment rausgenommen, da 2012und 2013 fast komplett entfernt worden sind Calculate all Missing Dates from Main Data Tables Meta Data Analysis:How many missings were filled up? Amount of missings filled Auffüllen von MissingsFill up all missings with the same date of the next year. If the next year's date is a saturday, then use the next weekday, Cleanup Result of filling missings Finales Ergebnis FinalesErgebnisderMissings-Befüllung KUNNR = 0010002476LGORT = 0003BESTELLNR = 100005 oder 0000100005STORNO != XTonnageJahr Doubletten entfernenNode 112Node 122Node 123Node 124TagAlle (vorhandenen)Tage mit summierteGewichte2003-2018Lgort to INTFES_WaagenJoin Wiegedaten& Anlagenbased on LgortCreate month-daycolumnGet sum and countof net_weight for eachday over all yearsCalculate averageTurn to numberRemove decimalplacesAlle enthaltenen Tagevon 2003-2023All Missing DatesRemove double entriesfrom interval settingGet year, month, dayTurn int to doubleAverage valuesfor all missing datesAlle dates withoriginal and filled upvaluesFill all sundays with weight=0and all other missings with averageNode 291Get year, month, dayExtract DateUmformatieren für joinNode 2570Node 2572Node 2573Node 2574Create 365 lagsNode 2579Node 2581Node 2589Node 2590Node 2591Node 2594Node 2595Node 2596Node 2597Node 2598Node 2600Node 2603Node 26042019-2023Join all dataGet all HolidaysAdd column "isMissing"with value "true"for all missing datesJoin everythingAll non-missingsget "false" in columnisMissingFill missings with NEXT year'syear-month-weekdayRemoveholidays outsidetimeframeAdd columnisHoliday2014-20232003-2013LGORT = 0003STORNO != XNur SiedlungsabfälleNode 2651CleanupCleanupGet year, month, dayAll Missings,Sundays, andHolidaysGet year, month, dayFill up "false"for non-holidaysRemoveholidaysRemovemissingsMake missings,holidays = 0Remove SundaysBetter columnnamesCount how manyentries are leftRemove 0-weight entriesCount how manyentries are leftRemove 0-weight entriesAll missings +non missings(holidays unmarked)Node 2676Join for countRename forbetter usabilityTotal amount of missings filledRemove ? valuesRemove ? valuesAverage weightfor each year-month-weekDoubletten entfernenRemove unnecessarycolumnsBetter columnnamesSort by datesascendingALL dates withmissings filled upMake holidays = 0All missings (filled up)joined with all holidays (0)Removeholiday nameDoubletten entfernenFill missings with THIS year'syear-month-weekdayRow Splitter (Labs) Math Formula Extract Date&TimeFields DuplicateRow Filter String Manipulation SARIMA Learner SARIMA Predictor Numeric Scorer Joiner Line Plot AggregationGranularity GroupBy Excel Reader String To Number CSV Reader Joiner String Manipulation GroupBy Column Expressions String To Number String Manipulation Create Date&TimeRange Joiner DuplicateRow Filter Extract Date&TimeFields Math Formula Joiner Joiner Rule Engine Column Rename Extract Date&TimeFields String Manipulation String to Date&Time Deployment Loop Keras LSTM Layer Keras Input Layer Keras Dense Layer Keras NetworkLearner Lag Column Partitioning Column Aggregator Line Plot Numeric Scorer Column Filter AggregationGranularity AggregationGranularity Joiner RowID Sorter Row Filter Partitioning Joiner AggregationGranularity AggregationGranularity Joiner Numeric Outliers Excel Reader Joiner CSV Reader Column Expressions Joiner Rule Engine Python Script Row Filter Column Expressions Test Dashboard Row Filter Row Filter Row Splitter (Labs) Rule-basedRow Filter Joiner Column Filter Column Filter Extract Date&TimeFields Joiner Extract Date&TimeFields Rule Engine Row Filter Row Filter Rule Engine Row Filter Column Rename GroupBy Row Filter GroupBy Row Filter Joiner Column Rename Joiner Column Rename Python Script Missing Value Missing Value GroupBy DuplicateRow Filter Column Filter Column Rename Sorter RowID Rule Engine Joiner Column Filter DuplicateRow Filter Python Script

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: DataScienceSS23-17
Created at: 2023-05-23
On NodePit since: 2023-09-04
Last update: 2024-04-26
Created with KNIME version: v4.7.3

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

Try NodePit Runner!