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

# 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

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

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.


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