Skip to main content

Remove

Remove lets you remove duplicates from a dataset.

Format

Remove uses a single format: Remove the duplicates (from the dataset <dataset>) (using the columns <columns>).

Parameters

Remove uses the following parameters:

  • dataset (optional). The dataset to remove duplicates from. If no dataset is specified, the current dataset is used.
  • columns (optional). The columns to remove duplicates from. If no columns are specified, all of the columns in the dataset are used.

Output

If the duplicates are successfully removed, a success message appears in the conversation history. When removing duplicates, the cleaned dataset (or columns, if specified) are shown in the Data tab. Otherwise, an error message appears.

Examples

To remove duplicates from a dataset called "Titanic," enter Remove the duplicates from the dataset Titanic.