# 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

![](/files/-M4oNBfIIN1mBK-oHqdk)

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

## Impute NA

![](/files/-M4oNBfMMTINRd4wkeo-)

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

1. `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)>.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.exploratory.io/data-wrangling/impute_na.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
