1.1 - 8.10 - FMeasure Example: Output Specified Classes - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Input

SQL Call

SELECT * FROM FMeasure (
  ON computers_category PARTITION BY 1
  USING
  ObservationColumn ('expected_compcategory')
  PredictColumn ('predicted_compcategory')
  Classes ('special','hyper')
  Beta (1.0)
) AS dt;

Output

 class   precision          recall             beta fmeasure           
 ------- ------------------ ------------------ ---- ------------------ 
 special            0.84375 0.8852459016393442  1.0              0.864
 hyper   0.9368421052631579               0.89  1.0 0.9128205128205129

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.