TD_SimpleImputeFit Function | SimpleImputeFit| Teradata Vantage - TD_SimpleImputeFit - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

TD_SimpleImputeFit is a data cleaning function that assigns missing values in a dataset. When working with real-world data, it is not uncommon to have missing values in some of the variables. This can cause problems when trying to perform data analysis or modeling. In such cases, it may be necessary to impute the missing values with plausible estimates to ensure that the data is complete and suitable for further analysis.

The TD_SimpleImputeFit function replaces the missing values with the mean, median, or most frequent value of the feature, depending on the imputation strategy selected. The function can also handle numeric and categoric features, and can be used with machine-learning models.

For example, you have a dataset of patient records, including variables such as age, gender, blood pressure, and cholesterol levels. However, due to some missing values in the dataset, some patients' records are incomplete. The blood pressure variable is missing for some patients, while the cholesterol levels variable is missing for others. This can cause problems when trying to perform data analysis or modelling on the dataset.

To address this issue, use the TD_SimpleImputeFit function to assign the missing values with plausible estimates. You can impute missing values in the systolic blood pressure with the mean value of all patients in the dataset. Similarly, you can impute missing values in the cholesterol levels variable with the median value of the cholesterol levels of all patients in the dataset.

TD_SimpleImputeFit outputs a table of values to substitute for missing values in the input table. The output table is input to TD_SimpleImputeTransform, which makes the substitutions.