# 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://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oNA_hYXJDEoCRHZoR%2Ffilter_custom.png?generation=1586795471403940\&alt=media)

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.