Remove inconsistent entries from data using ‘Remove outliers’

The remove outlier function allows you to remove the inconsistent entries from your data.

Step 1: Select the data from the left file tree or from “files” tab which needs to be manipulated.

Step 2: Once you select the file, it will be opened in the “Data Wrangler”.

Step 3: Click on the “Remove outliers” and a popup will appear.

Step 4: Click on the columns in which you want to apply remove outliers under “Select data”.

Step 5: After selecting the columns, that cell value in your data file is removed which has the cell value either greater than or less than the threshold value you have set.

Step 6: The default “Result” is to overwrite the original file with the updated file.

Select what you want to save as your output file from the “output” drop down menu.

If you want to keep the original file along with your updated file then, click on “Keep all columns” or “only keep selected columns” under “create new file”. Click “run”. The new file will be saved in the same folder as original file.