Exploratory
CtrlK
  • Introduction
  • Product Features
  • AI
  • 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
On this page

Was this helpful?

Data Wrangling

Command Line mode for faster and more flexible data interaction in ExploratorySelect / Remove ColumnsReorder ColumnsCreate New CalculationCreate New Calculation for Multiple ColumnsSummarize (Aggregate)GroupFilterRenameArrange (Sort)Top / Bottom NJoinMergeGatherSpreadPivotExpandCompleteSeparateUniteBind RowsBind ColumnsKeep Only Unique RowsKeep Only Duplicated RowsSliceDrop NASampleImpute NAFillCreate BucketsAssign New Values to Existing Values - RecodeAssign New Values by Setting Conditions - Case WhenWork with CategoriesData Type ConversionRow as headerUngroupUnnestSeparate List Items into Columns (Unnest Wider)Separate List Items into Rows (Unnest Longer)Separate Address (Japan)HoistRemove Empty RowsRemove Empty ColumnsClean Column NamesWindow CalculationWindow Calculation (日本語)Add RowText WranglingRegular Expression Cheat SheetRegular Expression Cheat Sheet (日本語)
PreviousCreate Custom Data SourceNextCommand Line mode for faster and more flexible data interaction in Exploratory

Last updated 4 years ago

Was this helpful?