DecisionForestEvaluator Example 2: Variable Importance - Teradata Vantage

This example calculates the overall variable importance by averaging the importance over 50 trees.

Input

• Input table: rft_model, output by any of the DecisionForest Examples

SQL Call

SELECT variable_col, SUM(importance)/50
  FROM DecisionForestEvaluator (
   ON rft_model
  ) AS dt GROUP BY variable_col ORDER BY 2 DESC;

Output

Variable importance is in descending order. The top three variables for modeling and prediction are price, lotsize, and bedrooms.