KNIME Weather Data Cleaning and Model Training
This workflows reads data from Snowflake database containing sensor readings. Seconds are removed in time stamps and temperature readings are averaged over the hour. Missing timestamps are introduced and filled using Linear Interpolation. Reasonable number of rows are considered for training and testing. Data is partitioned and SARIMA model is trained, finally results are visualized in the component along with original values.
URL: S.A.R.I.M.A. Seasonal ARIMA Models with KNIME https://www.knime.com/blog/sarima-seasonal-arima-models-with-knime
URL: An Introduction to Integrated Deployment https://www.knime.com/blog/integrated-deployment-blog-series-episode-1-an-introduction-to-integrated-deployment
Nodes
- Rule Engine Variable10 ×
Table Row to Variable9 ×- Column Filter8 ×
- GroupBy8 ×
- Integer Configuration8 ×
- Joiner8 ×
- Math Formula8 ×
- Column Rename (Regex)7 ×
- Row Filter7 ×
- End IF6 ×
- Breakpoint5 ×
- String to Date&Time5 ×
- Column Selection Configuration4 ×
- Create Date&Time Range4 ×
- Extract Table Dimension4 ×
- Merge Variables4 ×
- Python Predictor4 ×
- RowID4 ×
- Single Selection Configuration4 ×
- CASE Switch Data (End)3 ×
- CASE Switch Data (Start)3 ×
- Column Rename3 ×
- Extract Table Spec3 ×
- IF Switch3 ×
- Rule Engine3 ×
- Sorter3 ×
- Boolean Configuration2 ×
- CASE Switch Variable (Start)2 ×
- Conda Environment Propagation2 ×
- Constant Value Column2 ×
- Java Edit Variable2 ×
- Math Formula (Variable)2 ×
- Missing Value2 ×
- String Manipulation2 ×
- Table Creator2 ×
- Table Row to Variable2 ×
- Transpose2 ×
- Catch Errors (Data Ports)1 ×
- Cell Splitter1 ×
- Concatenate1 ×
- DB Reader (Labs)1 ×
- DB Table Selector (Labs)1 ×
- Domain Calculator1 ×
- Empty Table Creator1 ×
- Extract Date&Time Fields1 ×
- Line Plot (JavaScript)1 ×
- Model Writer1 ×
- Numeric Scorer1 ×
- Partitioning1 ×
- Python Learner1 ×
- Rule-based Row Filter1 ×
- Snowflake Connector1 ×
- Statistics1 ×
- String To Number1 ×
- Tile View (JavaScript)1 ×
- Top k Row Filter1 ×
- Try (Data Ports)1 ×
Extensions
- FeatureKNIME Base nodes
- FeatureKNIME Conda Integration
- FeatureKNIME Data Generation
- FeatureKNIME Database
- FeatureKNIME JavaScript Views
- Show all 12 modules
Links
- No links available