TD_OneHotEncodingTransformの例 - Advanced SQL Engine - Teradata Database

• InputTable: onehotencoding_input (TD_OneHotEncodingFitの例と同様)
• FitTable: TD_OneHotEncodingFitの例によって作成されたonehotencodingfit_output

SQL呼び出し

SELECT * FROM TD_OneHotEncodingTransform (
  ON onehotencoding_input AS InputTable PARTITION BY ANY
  ON onehotencodingfit_output AS FitTable DIMENSION
  USING
  IsInputDense ('true')
) AS dt;

出力

 Passenger Survived Pclass Name               Age Sex_male Sex_female Sex_other 
 --------- -------- ------ ------------------ --- -------- ---------- --------- 
         1        0      3 Mr. Owen Harris     22        1          0         0
         4        0      3 Mrs. Jacques Heath  35        0          1         0
         3        1      3 Mrs. Laina          26        0          1         0
         2        1      1 Mrs. John Bradley   38        0          1         0