Icon

Solutions

8 workflows in this folder and its subfolders

Icon
01 Date and Time Manipulation - Solution

October 2020 · 01 Date and Time Manipulation - Solution Solution to an exercise for data and time manipulation. Transform date and time values from string to the dedicated Date&Time format. Remove redundant digits from the timestamps. Extract the day of the week from the dates, and aggregate the data. CHECK YOUR A…

Icon
02 Database Data Manipulation - Solution

October 2020 · 02 Database Data Manipulation - Solution Solution to an exercise for database data manipulation. Write a local data table into a database. Aggregate, join, and filter the data on the database. Read the manipulated data back into KNIME. CHECK YOUR ANSWERS: 38843 rooms out of the 49079 listed rooms ha…

Icon
03 Flow Variables - Solution

October 2020 · 03 Flow Variables - Solution Solution to an exercise for creating and using flow variables. Filter data based on a previous result in a workflow CHECK YOUR ANSWERS: The host id with the most listings offers 327 rooms/apartments located in Manhattan VIDEO: From Data to Variables https://youtu.be/wJaD…

Icon
04 Components - Solution

October 2020 · 04 Components - Solution Solution to an exercise for creating a component and using a shared component. Create a component that filters data based on a user selection. Drag and drop a component from the KNIME Hub, and use it in your workflow. CHECK YOUR ANSWERS: 1036 rooms are available in Manhattan…

Icon
05 Loops - Solution

October 2020 · 05 Loops - Solution Solution to an exercise for building loops. Build a generic loop that stops when a predefined condition is met. Build a group loop that handles each subgroup of the data in a separate iteration. CHECK YOUR ANSWERS: You could stay at maximum 15 nights for $150 VIDEO: What is a Loo…

Icon
06 Switches - Solution

October 2020 · 06 Switches - Solution Solution to an exercise for building an IF switch. Execute one of two parallel branches separated by an IF switch node. Collect the results of the alternative branches with an End IF node, and continue with tasks that are common to both workflow branches. Make a user selection…

Icon
07 Random Forest - Solution

October 2020 · 07 Random Forest - Solution Solution to an exercise for training a Random Forest model. Build a Random Forest (Regression) model on a training set. Apply it to a test set, and evaluate the model's performance with numeric scoring metrics. CHECK YOUR ANSWERS: Prediction of a room price deviates in av…

Icon
08 Parameter Optimization - Solution

October 2020 · 08 Parameter Optimization - Solution Solution to an exercise for building a parameter optimization loop. Optimize the number of trees in a Random Forest model with a parameter optimization loop CHECK YOUR ANSWERS: The optimal number of trees is 80 VIDEO: Parameter Optimization for Prediction Models…