- Command Line Mode - Type R functions directly instead of using the UI.
- Select / Remove Columns - Select or remove columns by column name.
- Reorder Columns - Reorder columns by drag and drop.
- Create New Calculation - Create new columns with given expressions and preserve existing columns.
- Create New Calculation for Multiple Columns - Apply a new calculation to multiple columns.
- Summarize (Aggregate) - Summarize (aggregate) the data.
- Group Rows - Convert the data frame into a grouped data frame so that following operations are performed by group.
- Filter - Return rows that match conditions.
- Rename - Rename existing column names.
- Arrange (Sort) - Sort rows by given columns.
- Top / Bottom N - Keep only the top or bottom N rows.
- Join Data - Join rows from the data frame with rows from another data frame by matching values of key columns.
- Merge multiple Data Frames - Merge multiple data frames by row.
- Gather (Unpivot) - Take multiple columns and collapse them into key-value pairs.
- Spread - Spread a key-value pair across multiple columns.
- Pivot - Pivot columns into rows and columns.
- Expand - Expand a data frame to include all combinations of values.
- Complete - Turn implicit missing values into explicit missing values and complete missing combinations of data.
- Separate - Separate a column with delimited values into multiple columns or rows.
- Unite - Unite columns.
- Bind Rows - Bind multiple data frames by row.
- Bind Columns - Bind multiple data frames by column.
- Keep Only Unique Rows - Keep only unique rows.
- Keep Only Duplicated Rows - Keep only duplicated rows.
- Slice - Select rows by positions.
- Drop NA - Drop rows that have NA values.
- Sample - Sample N rows or a fraction of rows from the data frame.
- Impute NA - Impute NA by average or median values, manually entered values, or predicted values.
- Fill - Fill missing values using the previous entry.
- Create Buckets - Categorize numeric values into a set of buckets.
- Assign New Values to Existing Values - Recode - Map existing values to new values with an easy-to-use dialog.
- Assign New Values by Setting Conditions - Case When - Assign new values to a column by setting conditions with an easy-to-use dialog.
- Working with Categorical Data - Work with categorical data.
- Type Convert - Guess the data type of each column by reading the first 1000 rows, parse the data and set appropriate data types.
- Row as Header - Use a row as column names.
- Ungroup - Remove the grouping.
- Unnest - Unnest a list column or a list of data frames into its own rows.
- Separate List Items into Columns (Unnest Wider) - Unnest a list column or a list of data frames into its own columns.
- Separate List Items into Rows (Unnest Longer) - Unnest a list column or a list of data frames into its own rows.
- Separate Address (Japan) - Separate a Japanese address into prefecture, city and street columns.
- Hoist - Selectively pull components of a list column out into their own top-level columns.
- Remove Empty Rows - Remove all rows that are composed entirely of NA values.
- Remove Empty Columns - Remove all columns that are composed entirely of NA values.
- Clean Column Names - Clean up all column names on the data frame.
- Window (Table) Calculation - Window Calculation is available for Numeric, Date, and Time columns.
- Add Row - Add a row by passing column name-value pairs.
- Text Wrangling UI - Remove, replace and extract strings from your text data.
- Regular Expression - Use regular expressions inside the Text Data Wrangling UI.
Data Wrangling
Data Wrangling
Data wrangling is how you shape your data before you chart or analyze it. You build it step by step with the UI or by typing R functions in Command Line Mode, and each operation is kept as a step.
