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

Last updated