Welcome to the Datanyx Community!

Get Help, Learn Best Practices, Network With Other Datanyx Users
I need to replace t...
 
Notifications
Clear all

I need to replace the values that lie beyond the min and max value quantiles with the boundary values of the min and max quantile. How do I do this?

1 Posts
1 Users
0 Likes
224 Views
Nikhila
(@nikhila)
Member Admin
Joined: 2 years ago
Posts: 338
Topic starter  

Step 1: Once data has been imported, click on data preparation. (Refer to the image below).  

1671710962-datapreparation.png
Step 2: Drag and drop the outlier treatment node onto the main screen. Connect the two nodes. (Refer to the image below). 
1671711192-OutlierTreatmenticons.png
Step 3: Once a successful connection is made between ‘data import and outlier treatment’, click on the select button. An outlier treatment pop-up appears with the columns present in the data. Click on ‘Apply’. (Refer to the image below). 
1677051925-outliertreatment.png
Step 4: Click on IQR (Inter Quartile Range). The user needs to add range for dropping the rows which lie above or below the given quantiles. (Refer to the image below). 
1671711025-outliertreatment1.png

Step 5: Click on ‘Z-score Normalization’ to normalize the numeric data. 

Step 6: Click on ‘Winsorization’ to impute the outlier values by giving the range. (Refer to the image below).  

1671711099-outliertreatment2.png
Note: The user can run the workflow for individual nodes as well.

   
Quote
Share: