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
Select "Custom" tab.
Type in the R Expression for the filtering condition in "Condition" field.
Click "Run" to filter the rows based on the condition.
Last updated
