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