Icon

Group Project Clean Data

Linear Regression

Data Cleaning and Preparation

Lag 1

Lag 2

Lag 3

Outlier Detection with Hampel Filter Technique

Outlier Detection with Hampel Filter Technique

Outlier Detection with Hampel Filter Technique

Outlier Detection with Hampel Filter Technique

Outlier Detection with Hampel Filter Technique

Prepare Data for Lag 2

Prepare Data for Lag 3

Clean 'Change %' and 'Vol.' Column

Clean 'Change %' and 'Vol.' Column

Value -> Gold_Price(USD)
Column Renamer
Rule Engine
Moving Aggregator
Lag Gold_Price (THB)
Lag Column
Math Formula
Compute Gold_Return
Math Formula
Math Formula
Join Gold_Price(USD) with Exchange rateand base date on bottom input
Joiner
Value Counter
Rearrange Columns
Column Resorter
Moving Aggregator
Lag Oil_Price (THB)
Lag Column
Rule Engine
Compute Oil_Return
Math Formula
Remove missing row (First row)
Row Filter
Join Gold and Oil data
Joiner
Oil_Return(-2)
Linear Regression Learner
Rename (-1)(-1) to (-2)
Column Renamer
USD -> THB
Math Formula
R^2 0.308RMSE 0.035
Numeric Scorer
Set_Return : Linear interpolationFill in number that is N/A
Missing Value
R^2 0.292RMSE 0.035
Numeric Scorer
Regression Predictor
Regression Predictor
Join Inflation (-1), Gold_Return(-1), Oil_Return(-1), GoldtoOil_Price_Ratio(-1) with SetCON_Return
Joiner
Rename (-2)(-1) to (-3)
Column Renamer
Box plot of Oil_Return
Box Plot
Join Inflation (-1) with Gold_Return(-1), Oil_Return(-1), GoldtoOil_Price_Ratio(-1)
Joiner
Line plot of Oil_Return
Line Plot
Lag GoldtoOil_Price_Ratio
Lag Column
Compute GoldtoOil_Price_Ratio
Math Formula
Gold_Return(-3)
Linear Regression Learner
Line Plot of Inflation
Line Plot
80/20
Table Partitioner
Line plot of Gold_Return
Line Plot
R^2 0.284RMSE 0.035
Numeric Scorer
GoldtoOil_Price_Ratio(-3)
Linear Regression Learner
Regression Predictor
80/20
Table Partitioner
Oil price (USD)
Excel Reader
80/20
Table Partitioner
MCOILBRENTEU -> Oil_Price(USD)observation -> Date
Column Renamer
Ascending Date
Sorter
String to Date&Time
CPI (THB) from string to number
String to Number
Remove duplicate date
Duplicate Row Filter
String to Date&Time
Lag Gold Return
Lag Column
Lag GoldtoOil_Price_Ratio(-1)
Lag Column
Lag Oil Return
Lag Column
Compute SetCON_Return
Math Formula
Math Formula
Lag Price
Lag Column
String to Number
change %/100
Math Formula
String to Number
Row Filter
R^2 0.325RMSE 0.034
Numeric Scorer
Remove duplicate date
Duplicate Row Filter
Ascending Date
Sorter
Row Filter
Concatenate
Gold_Return(-2)
Linear Regression Learner
Oil_Return(-3)
Linear Regression Learner
Join Inflation (-1), Gold_Return(-1), Oil_Return(-1), GoldtoOil_Price_Ratio(-1), SetCON_Return with Set_Return
Joiner
Regression Predictor
R^2 0.317RMSE 0.034
Numeric Scorer
String Replacer
Lag Gold_Return(-1)
Lag Column
String Replacer
Excel Writer
Regression Predictor
Select only (-2) and Date, SetCON_Return, Set_Return
Column Filter
Lag Oil_Return(-1)
Lag Column
80/20
Table Partitioner
Math Formula
R^2 0.363RMSE 0.033
Numeric Scorer
GoldtoOil_Price_Ratio(-2)
Linear Regression Learner
Math Formula
Regression Predictor
Gold Price (USD)
CSV Reader
Change % from string to number
String to Number
80/20
Table Partitioner
Lag Inflation(-1)
Lag Column
SET CONSUMER (thb)
CSV Reader
80/20
Table Partitioner
Ascending date
Sorter
String to Date&Time
R^2 0.293RMSE 0.035
Numeric Scorer
Box Plot of Inflation
Box Plot
Remove duplicate date
Duplicate Row Filter
Regression Predictor
Box plot of Gold_Return
Box Plot
Math Formula
Box Plot
String Cleaner
GoldtoOil_Price_Ratio(-1)
Linear Regression Learner
Moving Aggregator
80/20
Table Partitioner
Ascending Date
Sorter
Gold_Return(-1)
Linear Regression Learner
Inflation : Use Linear interpolationFill in number that is N/A
Missing Value
Rule Engine
80/20
Table Partitioner
Moving Aggregator
Exchange rate
Excel Reader
Column Renamer
Remove duplicate date
Duplicate Row Filter
R^2 0.278RMSE 0.035
Numeric Scorer
Value Counter
Join Oil_Price(USD) with Exchange rateand base date on top input
Joiner
Value Counter
USD -> THB
Math Formula
Regression Predictor
Rule Engine
Ascending Date
Sorter
80/20
Table Partitioner
Math Formula
use previous value if missing
Missing Value
Oil_Return(-1)
Linear Regression Learner
Rule Engine
R^2 0.3RMSE 0.035
Numeric Scorer
Moving Aggregator
Gold_Return : Linear interpolationFill in number that is N/A
Missing Value
Math Formula
Regression Predictor
Moving Aggregator
Rule Engine
Remove % from change % column
String Replacer
Line Plot
String to Number
Compute Set_Return
Math Formula
Box Plot
Lag GoldtoOil_Price_Ratio(-2)
Lag Column
Concatenate
Lag Inflation(-2)
Lag Column
Row Filter
Lag Price
Lag Column
Lag Gold_Return(-2)
Lag Column
Lag Inflation
Lag Column
Select only (-3) and Date, SetCON_Return, Set_Return
Column Filter
Math Formula
Lag Oil_Return(-2)
Lag Column
String to Date&Time
String to Number
Line Plot
SET index
CSV Reader
Remove duplicate date
Duplicate Row Filter
Math Formula
String Replacer
Rule Engine
Remove % from change % column
String Replacer
Moving Aggregator
String to Number
Moving Aggregator
Oil_Return : Linear interpolationFill in number that is N/A
Missing Value
Math Formula
Math Formula
Rule Engine
Row Filter
Value Counter
Remove missing row (First row)
Row Filter
Remove missing row (First row)
Row Filter
String Replacer
Math Formula
String to Number
Row Filter
Remove missing row (first row)
Row Filter
String Replacer
Math Formula
CPI (THB)
Excel Reader
Math Formula
Moving Aggregator
Change % from string to number
String to Number
Moving Aggregator
change %/100
Math Formula
Math Formula
lag CPI 1 period
Lag Column
Rule Engine
Compute Inflation
Math Formula
Rule Engine
Remove duplicate date
Duplicate Row Filter
Ascending Date
Sorter
Value Counter
SetCON_Return : Linear interpolationFill in number that is N/A
Missing Value
String Replacer
Remove first row
Row Filter
Remove missing row (First row)
Row Filter
00000 -> CPI (THB)รหัส -> Date
Column Renamer
Row Filter

Nodes

Extensions

  • No modules found

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: aime
Created at: 2026-06-22
On NodePit since: 2026-07-10
Last update: 2026-07-10
Created with KNIME version: v5.11.0

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

Try NodePit Runner!