SVMDensePredict Example: Radial Basis Model (RBF) Model | Teradata Vantage - SVMDensePredict Example: Radial Basis Model (RBF) Model - Teradata Vantage

Input

• InputTable: svm_iris_test (see SVMDense Examples Input)
• Model: densesvm_iris_rbf_model (see SVMDense Example: Radial Basis Model (RBF) Model)

SQL Call

SELECT * FROM SVMDensePredict (
  ON svm_iris_test AS InputTable PARTITION BY ANY
  ON densesvm_iris_rbf_model AS Model DIMENSION
  USING
  IdColumn ('id')
  TargetColumns ('[1:4]')
  Accumulate ('id','species')
  Responses ('setosa','virginica','versicolor')
) AS dt ORDER BY id;

Output

id predict_value  prob_setosa           prob_virginica         prob_versicolor       species
----------- ----------------------------------------------------------------------------------- 
  5 setosa       8.53099686722651E-001  7.12123740735055E-002  7.56879392038434E-002 setosa
 10 setosa       8.36774797899848E-001  7.90006283278393E-002  8.42245737723125E-002 setosa
 15 setosa       8.19072970899937E-001  8.36300294092617E-002  9.72969996908008E-002 setosa
 20 setosa       8.40077234152427E-001  7.03669845228139E-002  8.95557813247589E-002 setosa
 25 setosa       7.97324431957191E-001  8.17163663559750E-002  1.20959201686834E-001 setosa
 30 setosa       8.34816911757391E-001  7.61040058049542E-002  8.90790824376544E-002 setosa
 35 setosa       8.38524299726096E-001  7.78162831313889E-002  8.36594171425148E-002 setosa
 40 setosa       8.43823410461091E-001  6.55816742510724E-002  9.05949152878370E-002 setosa
 45 setosa       7.97396679235347E-001  7.56138045058258E-002  1.26989516258827E-001 setosa
 50 setosa       8.46318621228370E-001  7.63293079531446E-002  7.73520708184855E-002 setosa
 55 versicolor   1.08667666703838E-001  1.28149661364142E-001  7.63182671932021E-001 versicolor
 60 versicolor   1.03486998751138E-001  9.29776810740721E-002  8.03535320174790E-001 versicolor
 65 versicolor   9.47396192130595E-002  5.49610056706921E-002  8.50299375116248E-001 versicolor
 70 versicolor   8.31065113324146E-002  7.13819369488294E-002  8.45511551718756E-001 versicolor
 75 versicolor   8.14228893787075E-002  5.27416731609616E-002  8.65835437460331E-001 versicolor
 80 versicolor   9.94901242891676E-002  6.00628318690182E-002  8.40447043841814E-001 versicolor
 85 versicolor   1.19089151291437E-001  1.80004039865378E-001  7.00906808843185E-001 versicolor
 90 versicolor   9.75913912013310E-002  1.01061902060004E-001  8.01346706738666E-001 versicolor
 95 versicolor   8.56003265812562E-002  9.72277208973315E-002  8.17171952521412E-001 versicolor
100 versicolor   7.87653390786804E-002  6.76784096081217E-002  8.53556251313198E-001 versicolor
105 virginica    6.91484995721781E-002  8.77085216942167E-001  5.37662834856548E-002 virginica
110 virginica    8.39653099581198E-002  8.54153047254068E-001  6.18816427878126E-002 virginica
115 virginica    9.06048065134211E-002  8.24227021766157E-001  8.51681717204218E-002 virginica
120 versicolor   1.24753191978444E-001  3.55596486828223E-001  5.19650321193333E-001 virginica
125 virginica    8.95813023511484E-002  8.27394240784264E-001  8.30244568645873E-002 virginica
130 virginica    1.19179971465709E-001  6.96221507392719E-001  1.84598521141572E-001 virginica
135 virginica    1.24129672458367E-001  6.40688896090047E-001  2.35181431451587E-001 virginica
140 virginica    9.65988019626372E-002  7.82891544823156E-001  1.20509653214207E-001 virginica
145 virginica    7.57981864235314E-002  8.68764706679798E-001  5.54371068966706E-002 virginica
150 virginica    1.14114530651815E-001  6.97759150368903E-001  1.88126318979282E-001 virginica

Download a zip file of all examples and a SQL script file that creates their input tables.