Icon

Exercises

This directory contains 11 workflows.

Icon01 Read Data from File 

Exercise for reading data from a file URL: File Reader https://youtu.be/flaHQw-Qhlg URL: Table Reader https://youtu.be/tid1qi2HAOo URL: Excel Reader […]

Icon02 Accessing Databases 

Exercise for reading data from a database

Icon03 Row and Column Filtering 

Exercise for filtering rows and columns

Icon04 Data Transformation 

Exercise for transforming data. Perform data transformations with the Rule Engine, Math Formula, and String Manipulation nodes, or alternatively, with […]

Icon05 Data Visualization 

Exercise for data visualization. Explore statistics and relationships in data with the Data Explorer, Scatter Plot, and Table View nodes. Build an […]

Icon06 Aggregations 

Exercise for data aggregation. Calculate summary statistics for subgroups of data with the GroupBy and Pivoting nodes

Icon07 Join and Concatenate 

Exercise for joining and concatenating data. Combine data tables side-by-side using the join operation. Put tables on top of each other with the […]

Icon08 Regression Model 

Exercise for training a model for numeric prediction. Train and apply a linear regression model. Evaluate the performance with numeric scoring […]

Icon09 Decision Tree Model 

Exercise for training a classification model. Train and apply a decision tree model. Evaluate the model's performance with scoring metrics and an ROC […]

Icon10 Write Data to a File 

Exercise for exporting data. Aggregate data and write the results into a CSV file.