# Filter

Return rows with matching conditions

### Operators

When creating a filter, Exploratory supports below operators for each column data type.

#### Numeric

* Equal To
* Not Equal To
* Is In (Multiple Values)
* Is Not In (Multiple Values)
* Less Than
* Less Than or Equal To
* Greater Than
* Greater Than Or Equal To
* Between
* Not Between
* Is NA
* Not NA
* Is Outlier
* Not Outlier

As For Outlier operator, we support IQR (Interquartile Range), 95 Percentile, 99 Percentile, 2 Standard Deviation, and 3 Standard Deviation as Type of Outlier Detection. Also, you can specify the Range from following options:

* Upper and Lower
* Upper
* Lower

So if you select "Is Outlier" and "95 Percentile" as Type of Detection, and "Upper" as the Range, it only keeps data that fit inside Upper 95 Percentile.

#### Character

* Starts With
* Not Starts With
* Ends With
* Not End With
* Contains
* Not Contain
* Keep Only Stopword
* Remove Stopword
* Keep Only Alphabet
* Remove Alphabet
* Remove Empty
* Keep Only Empty
* Is NA
* Not NA

### Date / Time

* Relative Date
* Equal To
* Not Equal To
* Is In (Multiple Values)
* Is Not In (Multiple Values)
* Earlier Than
* Earlier Than or Equal To
* Later Than
* Later Than Or Equal To
* Between
* Not Between
* Is NA
* Not NA

## Filter by Custom R Expression

![](/files/-M4oNA_hYXJDEoCRHZoR)

1. Select "Custom" tab.
2. Type in the R Expression for the filtering condition in "Condition" field.
3. Click "Run" to filter the rows based on the condition.


---

# 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/filter.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.