Exploratory
Search
K

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

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