Predictor
Train the model to predict a column with a fixed set of values.
Train the model to predict a column with a fixed set of values.
This tool considers all classification modelling tools and regression modelling tools. Varicent ELT uses the tool with the best score to make a prediction.
Note
The speed and quality slider is more of a spectrum. This setting determines the number of machine learning models considered. Models that do not support the training data are automatically excluded.
This tool adds two columns to your data: a prediction and a probability. The probability is the likelihood that the prediction is accurate.
When you run the tool, the data is automatically split: 80% of the data is used for training. The remaining 20% is used for testing. Each model being considered is trained and evaluated to select the one with the best score. This is done 5 times to predict the test values (the 20% of your data). The final score is the average of all 5 scores.
Tip
You can configure this tool without using the configuration menu.
In the menu, start typing the first few letters of the tool name and press tab to auto-complete. Then start typing the name of the column you want to use and press tab to auto-complete.
Data profile chart visuals
From the Row viewer, you can access the Data profile link to open the column details and compare column visuals.
From the Row viewer, you can access the Data profile link to open the column details and compare column visuals. The results are available when you select one of the Classifier, Predictor or Regressor tools.
In your selected pipe, go to the Row viewer.
Click on the Data profile link in the row viewer.
The Data profile page opens with column details and compare column visuals.
Note
If you have an explainable tool upstream, you can still get an error message with one of the following issues:
The schema has changed in the export. For example, a missing column or an extra column is present.
There are multiple explainable tools in the pipe upstream.
The pipe changed and the calculation is now invalid.
If there is no Data profle link, there is no explainable tool selected in the pipe upstream.
When to use this tool
Use this when you want to make a prediction, but you're unfamiliar with classification and regression modelling tools. After you're comfortable with the difference between those tools, switch to using the Regressor or Classifier tool.
What is Smart exclude?
Following a successful build using the Predictor tool, Smart exclude identifies and automatically excludes columns that don’t help predict the target column. Smart exclude will only consider columns not already manually excluded. If you want to disable this setting to troubleshoot, test, or run a calculation that is taking too long, go to the Advanced settings under the Configure tab.