Icon

Solutions

11 workflows in this folder and its subfolders

Icon
01 Read Data from File - Solution

April 2020 · 01 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, Table Reader, and Excel Reader b. The adult.csv table has the most columns (13) VIDEO: File Reader https://youtu.…

Icon
02 Accessing Databases - Solution

April 2020 · 02 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 node VIDEO: The knime:// Protocol https://youtu.be/U9sP4g4yGwY VIDEO: Accessing Databases https://youtu.be/WW0j_n79pIg TAGS: data acc…

Icon
03 Row and Column Filtering - Solution

April 2020 · 03 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 married c. 7908 are never married and between 20 and 40 years old d. 4953 are with work class State-gov, Self-emp-n…

Icon
04 Data Transformation - Solution

April 2020 · 04 Data Transformation - Solution Solution to an exercise for transforming data. Perform data transformations with the Rule Engine, Math Formula, and String Manipulation nodes, or alternatively, with the Column Expressions node. CHECK YOUR ANSWERS: The ID 177 in the data has a. work status full-time…

Icon
05 Data Visualization - Solution

April 2020 · 05 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. Build an interactive view with a scatter plot and an interactive table. CHECK YOUR ANSWERS: Data Explorer: 39 diff…

Icon
06 Aggregations - Solution

April 2020 · 06 Aggregations - Solution Solution to an exercise for data aggregation. Calculate summary statistics for subgroups of data with the GroupBy and Pivoting nodes. CHECK YOUR ANSWERS: GroupBy: a. The average age is 37 years for the women and 39 years for the men b. Husband is the most common family rel…

Icon
07 Join and Concatenate - Solution

April 2020 · 07 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 with the concatenate operation. CHECK YOUR ANSWERS: Joiner: The number of rows is 32549 in all joined tables. No r…

Icon
08 Regression Model - Solution

April 2020 · 08 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 scoring metrics. CHECK YOUR ANSWERS: a. The model explains about 20% of the variance of the weekly working hours (R-squ…

Icon
09 Decision Tree Model - Solution

April 2020 · 09 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 and an ROC curve. CHECK YOUR ANSWERS: a. The overall accuracy of the model is around 86% b. The number of rows i…

Icon
10 Write Data to a File - Solution

April 2020 · 10 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 average younger (42 years) than men with income >50K (45 years) VIDEO: CSV Writer Node https://youtu.be/oq_X4lKK6SI T…