Welcome to the Datanyx Community!

Get Help, Learn Best Practices, Network With Other Datanyx Users
How do I scale the ...
 
Notifications
Clear all

How do I scale the values in specific columns to their respective Z scores?

1 Posts
1 Users
0 Likes
279 Views
Nikhila
(@nikhila)
Member Admin
Joined: 2 years ago
Posts: 338
Topic starter  
The user is able to scale down the values of the selected numerical columns to their respective Z scores.  
Step 1: Once data is imported, click on transformation.  
Step 2: Drag and drop the standardization node onto the main screen. Connect the two nodes. (Refer to the image below).  
1672915711-standardization.png

Step 3: Once a successful connection is made between ‘data import and standardization’, click on the select button. A pop-up appears with the columns present in the data.   

Step 4: The user is now able to choose the desired columns. 

Step 5: Click on ‘Apply’. (Refer to the image below).  

1677143280-standardization1.png
Step 6: Once the columns have been selected, click on the run button or the standardization node twice to run the workflow. Click on the icon in the bottom line. (Refer to the image below).  
1672915805-result.png
Step 7: The images of the before and after have been given below. The Column selected to be standardized is “Profit”. The data is reflected based on the operations selected. (Refer to the images below). 
1672915845-Tstandardization.png
1672915880-Tstandardization1.png
Note: The user can run the workflow for individual nodes as well.

   
Quote
Share: