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

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 (日本語)