FMeasure Example: Output Specified Classes - Teradata Vantage

Input

• computers_category, as in FMeasure Example: Output All Classes

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.