TD_SimpleImputeTransform Example | SimpleImputeTransform - Example: How to Use TD_SimpleImputeTransform - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢

TD_SimpleImputeTransform Input Table

 passenger pclass gender fare          survived 
 --------- ------ ------ ----          -------- 
         1      3 male   725.320000000        0
         2      1 female 712.250000000        1
         3   null female          null        1
         4      1 null   531.780000000        1
         5      3 male   805.210000000        0

Output Table from TD_SimpleImputeFit Function

 TD_INDEX_SIMFIT  TD_TARGETCOLUMN_SIMFIT  TD_NUM_COLVAL_SIMFIT  TD_STR_COLVAL_SIMFIT   TD_ISNUMERIC_SIMFIT 
 ---------------  ----------------------  --------------------  --------------------   ------------------- 
               1   pclass                      2.000000000         null                           1
               2   gender                             null         male                           0
               3   fare                      718.785000000         null                           1

Example: TD_SimpleImputeTransform SQL Call

SELECT * FROM TD_SimpleImputeTransform (
  ON simpleimputefit_input AS InputTable
  ON fit_table AS FitTable DIMENSION
) AS dt;

TD_SimpleImputeTransform Output

 passenger pclass gender fare          survived 
 --------- ------ ------ ----          -------- 
         5      3 male   805.210000000        0
         4      1 male   531.780000000        1
         3      2 female 718.785000000        1
         1      3 male   725.320000000        0
         2      1 female 712.250000000        1