Icon

JKISeason3-14_​sryu

Forecasting Avocado Prices


Level: Medium

Description: You are a data scientist asked to analyze an avocado dataset by your team. The task at hand is to pick a specific avocado type in the whole of the US and forecast its daily average prices. To do that, you should train, apply, and score an ARIMA model. Do you see any seasonality in the line plot or autocorrelation plots? Do you think a seasonal ARIMA (SARIMA) would perform better? For your model, visualize forecasts and compute scoring metrics.

ARIMA (Parameters optimization) SARIMA (Parameters optimization) Prediction with optimized model (SARIMA, p=2, d=2, q=1, P2, D=1, Q=1) Optimized parameters of ARIMAp = 4 , d = 0 , q = 4 Optimized parameters of SARIMAp = 2 , d = 2 , q = 1P = 2 , D = 1 , Q = 1 read dataMeanAveragePrice0: ~2017/31:2017/4~2018/3organicOptimization by TPEp: 0-5 P=0-2d:0-2 D=0-2d:0-5 Q=0-2Save ResultsOptimization by Brute Focep: 0-5d:0-2d:0-5ARIMA_Parameter_Search_Result.RMSEVisualization of parameter optimization results(ARIMA)Save Results0: ~2017/31:2017/4~2018/3RMSEascendingSARIMA_Parameter_Search_Result.round& renameVisualization of parameter optimization results(SARIMA)round& renameRMSEascendingPredicts two years into the future CSV Reader GroupBy Sorter Partitioning Row Filter String to Date&Time ARIMA Predictor Parameter OptimizationLoop Start SARIMA Learner(Labs) Variable toTable Row Line Plot Concatenate Column Appender Numeric Scorer Table Transposer Table Transposer Column Appender Image to Table String Manipulation(Variable) Table Reader Table Writer Concatenate ParameterOptimization Loop End Table Rowto Variable Table Transposer Column Appender Image to Table String Manipulation(Variable) Parameter OptimizationLoop Start Table Reader Numeric Scorer ParameterOptimization Loop End Table Rowto Variable Tile View(JavaScript) Variable toTable Row Table Reader Line Plot Concatenate Concatenate Table Writer Partitioning ARIMA Learner Joiner Column Renamer Sorter Table Reader Math Formula Tile View(JavaScript) Math Formula Sorter SARIMA Learner(Labs) SARIMA Predictor(Labs) Column Appender Create Date&TimeRange Concatenate Line Plot ARIMA (Parameters optimization) SARIMA (Parameters optimization) Prediction with optimized model (SARIMA, p=2, d=2, q=1, P2, D=1, Q=1) Optimized parameters of ARIMAp = 4 , d = 0 , q = 4 Optimized parameters of SARIMAp = 2 , d = 2 , q = 1P = 2 , D = 1 , Q = 1 read dataMeanAveragePrice0: ~2017/31:2017/4~2018/3organicOptimization by TPEp: 0-5 P=0-2d:0-2 D=0-2d:0-5 Q=0-2Save ResultsOptimization by Brute Focep: 0-5d:0-2d:0-5ARIMA_Parameter_Search_Result.RMSEVisualization of parameter optimization results(ARIMA)Save Results0: ~2017/31:2017/4~2018/3RMSEascendingSARIMA_Parameter_Search_Result.round& renameVisualization of parameter optimization results(SARIMA)round& renameRMSEascendingPredicts two years into the future CSV Reader GroupBy Sorter Partitioning Row Filter String to Date&Time ARIMA Predictor Parameter OptimizationLoop Start SARIMA Learner(Labs) Variable toTable Row Line Plot Concatenate Column Appender Numeric Scorer Table Transposer Table Transposer Column Appender Image to Table String Manipulation(Variable) Table Reader Table Writer Concatenate ParameterOptimization Loop End Table Rowto Variable Table Transposer Column Appender Image to Table String Manipulation(Variable) Parameter OptimizationLoop Start Table Reader Numeric Scorer ParameterOptimization Loop End Table Rowto Variable Tile View(JavaScript) Variable toTable Row Table Reader Line Plot Concatenate Concatenate Table Writer Partitioning ARIMA Learner Joiner Column Renamer Sorter Table Reader Math Formula Tile View(JavaScript) Math Formula Sorter SARIMA Learner(Labs) SARIMA Predictor(Labs) Column Appender Create Date&TimeRange Concatenate Line Plot

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: sryus
Created at: 2024-08-14
On NodePit since: 2024-08-18
Last update: 2024-11-17
Created with KNIME version: v5.3.1
Tags: JKISeason3-14ARIMASARIMA

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

Try NodePit Runner!