Exploratory
Search…
Exploratory
Introduction
Product Features
Data Import
Data Wrangling
Command Line mode for faster and more flexible data interaction in Exploratory
Select / Remove Columns
Reorder Columns
Create New Calculation
Create New Calculation for Multiple Columns
Summarize (Aggregate)
Group
Filter
Rename
Arrange (Sort)
Top / Bottom N
Join
Merge
Gather
Spread
Pivot
Expand
Complete
Separate
Unite
Bind Rows
Bind Columns
Keep Only Unique Rows
Keep Only Duplicated Rows
Slice
Drop NA
Sample
Impute NA
Fill
Create Buckets
Assign New Values to Existing Values - Recode
Assign New Values by Setting Conditions - Case When
Work with Categories
Data Type Conversion
Row as header
Ungroup
Unnest
Separate List Items into Columns (Unnest Wider)
Separate List Items into Rows (Unnest Longer)
Separate Address (Japan)
Hoist
Remove Empty Rows
Remove Empty Columns
Clean Column Names
Window Calculation
Window Calculation (日本語)
Add Row
Text Wrangling
Regular Expression Cheat Sheet
Regular Expression Cheat Sheet (日本語)
Visualization
Analytics
Statistics
Machine Learning
Text Analysis
Extend with R
Setup
Diagnostics
Keyboard shortcuts
Powered By GitBook
Filter
Return rows with matching conditions

How to Access This Feature

From + (plus) Button

  • Click "+" button and select "Filter".

From Column Menu

  • You can also select "Filter" from column menu of the column to apply filtering, and then select its submenu to choose the type of filtering.

Filter by Selecting Filtering Rule from UI

  1. 1.
    Select "Column" tab.
  2. 2.
    Select the column to apply the filtering condition from "Column" dropdown list.
  3. 3.
    Select operator for filtering condition from "Operator" dropdown list.
  4. 4.
    (Optional) Ignore Case - For Character related operators, you can enable Ignore Case to do case insensitive filtering.
  5. 5.
    Specify the detail of filtering condition by filling the rest of the fields in the dialog box. For "equal to" or "not equal to" condition value, you can either select (or type) value or select Parameter.
  6. 6.
    Click "Run" to filter the rows based on the condition.

Operators

When creating a filter, Exploratory Desktop 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

Date

  • Keep

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.
Previous
Group
Next
Rename
Last modified 6mo ago
Copy link
Contents
How to Access This Feature
From + (plus) Button
From Column Menu
Filter by Selecting Filtering Rule from UI
Operators
Date / Time
Filter by Custom R Expression