Icon

Exercises

11 workflows in this folder and its subfolders

Icon
01 Read Data from File

April 2020 · 01 Read Data From File Exercise for reading data from a file VIDEO: File Reader https://youtu.be/flaHQw-Qhlg VIDEO: Table Reader https://youtu.be/tid1qi2HAOo VIDEO: Excel Reader https://youtu.be/goo5ClHlfT8 VIDEO: The knime:// Protocol https://youtu.be/U9sP4g4yGwY TAGS: csv,data access,education,exc…

Icon
02 Accessing Databases

April 2020 · 02 Accessing Databases Exercise for reading data from a database VIDEO: The knime:// Protocol https://youtu.be/U9sP4g4yGwY VIDEO: Accessing Databases https://youtu.be/WW0j_n79pIg TAGS: data access,sqlite

Icon
03 Row and Column Filtering

April 2020 · 03 Row and Column Filtering Exercise for filtering rows and columns VIDEO: Row Filter: Removing Data Rows https://youtu.be/NJwWwpIEBpg VIDEO: Row Filter: Patter Matching. Include/Exclude Data Rows. https://youtu.be/j3YhdEgu0Z0 VIDEO: Row Filter. Numerical & Missing Values https://youtu.be/rBmGjMu9EG…

Icon
04 Data Transformation

April 2020 · 04 Data Transformation Exercise for transforming data. Perform data transformations with the Rule Engine, Math Formula, and String Manipulation nodes, or alternatively, with the Column Expressions node. VIDEO: Data Manipulation: Numbers, Strings, and Rules https://youtu.be/mJrBXmLQ4ko VIDEO: Column…

Icon
05 Data Visualization

April 2020 · 05 Data Visualization 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. VIDEO: Data Explorer https://youtu.be/iHr9V94Kxk8 URL: KNIME JavaScr…

Icon
06 Aggregations

April 2020 · 06 Aggregations Exercise for data aggregation. Calculate summary statistics for subgroups of data with the GroupBy and Pivoting nodes VIDEO: What is Data Aggregation? https://youtu.be/bDwF-TOMtWw VIDEO: The GroupBy Node: And how to use it https://youtu.be/JQ-OWMt48ew VIDEO: The Pivoting Node https:/…

Icon
07 Join and Concatenate

April 2020 · 05 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 concatenate operation. VIDEO: Joining Data Tables https://youtu.be/6BigLM6vbhs VIDEO: Joining Data Tables Part I: Inner Join https:…

Icon
08 Regression Model

April 2020 · 08 Regression Model Exercise for training a model for numeric prediction. Train and apply a linear regression model. Evaluate the performance with numeric scoring metrics. VIDEO: Numeric Scorer Node https://youtu.be/243VC3qkM-A TAGS: r-squared,error metric,linear regression

Icon
09 Decision Tree Model

April 2020 · 09 Decision Tree and Classification Model Evaluation 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. VIDEO: Decision Tree Learner Node: Algorithm Settings https://youtu.be/CSwM92yTrJw VIDEO:…

Icon
10 Write Data to a File

April 2020 · 10 Write Data to a File Exercise for exporting data. Aggregate data and write the results into a CSV file. VIDEO: CSV Writer Node https://youtu.be/oq_X4lKK6SI TAGS: export,csv