> For the complete documentation index, see [llms.txt](https://docs.exploratory.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.exploratory.io/data-wrangling/filter.md).

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