> ## Documentation Index
> Fetch the complete documentation index at: https://docs.exploratory.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Impute NA

Impute NA by average / median values, manually entered values, or predicted values. It will build a linear regression model for the prediction.

## How to Access This Feature

![](https://mintcdn.com/exploratory-inc/TqmeqBdjk6dsTTLj/en/wrangling/images/command-impute-na-menu.png?fit=max\&auto=format\&n=TqmeqBdjk6dsTTLj\&q=85\&s=9d7c0973fe50f353ab2ecb4876d65f1e)

* From Column Menu for Character Column, select "Map / Convert Data" ->  "Map NA to ..."

## Impute NA

![](https://mintcdn.com/exploratory-inc/mfFUqJbgNW8Lp3uy/en/wrangling/images/impute_na.png?fit=max\&auto=format\&n=mfFUqJbgNW8Lp3uy\&q=85\&s=3487db6b6b0eea0a39bdb78a2624e009)

In Calculation field, impute command is partially filled. So complete it by entering following.

1. `Column` - predictor column. this works only when type is "predict". Columns to be used as predictors.
2. `type`  - The default is "mean". Set how you want to impute NA. This can be numeric value to replace NA or types listed below.

* "mean" - Mean value
* "median" - Median value
* "value" - Replace the missing values with val
* "predict" - Predict possible values based on other columns

3. `val` (Optional) - This works when type is "value" or "predict". When it's "value", a value to replace NA or a column to replace NA at the same position. If it's "predict", a column to use for prediction of NA. More than one column can be used by indicating \<column(s)>.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.