Icon

Solutions

This directory contains 11 workflows.

Icon01 Read Data from File - Solution 

Solution workflow to an exercise for reading data from a file. CHECK YOUR ANSWERS: a. The reader nodes used in this exercise are CSV Reader/File Reader, […]

Icon02 Accessing Databases - Solution 

Solution to an exercise for reading data from a database. CHECK YOUR ANSWERS: The connector node to use here is the SQLite Connector […]

Icon03 Row and Column Filtering - Solution 

Solution to an exercise for filtering rows and columns. CHECK YOUR ANSWERS: Out of the adults in the data a. 4441 are divorced b. 10680 are never […]

Icon04 Data Transformation - Solution 

Solution to an exercise for transforming data. Perform data transformations with the Rule Engine, Math Formula, and String Manipulation nodes, or […]

Icon05 Data Visualization - Solution 

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

Icon06 Aggregations - Solution 

Solution to an exercise for data aggregation. Calculate summary statistics for subgroups of data with the GroupBy and Pivoting nodes. CHECK YOUR […]

Icon07 Join and Concatenate - Solution 

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

Icon08 Regression Model - Solution 

Solution to an exercise for training a model for numeric prediction. Train and apply a linear regression model. Evaluate the performance with numeric […]

Icon09 Decision Tree Model - Solution 

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

Icon10 Write Data to a File - Solution 

Solution to an exercise for exporting data. Aggregate data and write the results into a CSV file. CHECK YOUR ANSWERS: Women with income >50K are in […]