Icon

Exercises

8 workflows in this folder and its subfolders

Icon
00_​Building_​your_​first_​workflow_​optional_​Exercise

September 2020 · There has been no description set for this workflow's metadata.

Icon
01_​Data_​Access_​Exercise

April 2020 · Exercise 1 for the KNIME Analytics Platform for Data Wranglers course Import data from different file formats (csv, table, xls) Import data from SQLite database

Icon
02_​Data_​Merging_​Exercise

April 2020 · Exercise 2 for the KNIME Analytics Platform for Data Wranglers course Convert a column from number to string Concatenate data from two different sources Perform a lookup operation Join two database tables (using the DB Joiner node) and read database data into KNIME Join two local tables

Icon
03_​Data_​Cleaning_​Exercise

April 2020 · Solution to exercise 3 for the KNIME Analytics Platform for Data Wranglers course Explore the properties of the data with the Data Explorer node Manage numeric outliers Correct spelling mistakes manually and automatically Handle missing values Remove duplicate values

Icon
04_​Data_​Transformation_​Exercise

April 2020 · Exercise 4 for the KNIME Analytics Platform for Data Wranglers course Transform a data table with the Unpivoting node and remove superfluous rows and columns Format a string value using a combination of different manipulation nodes, e.g. Cell Splitter, Row Splitter, and String Manipulation

Icon
05_​Data_​Manipulation_​optional_​Exercise

April 2020 · Exercise 5 for the KNIME Analytics Platform for Data Wranglers course Create a new feature using the Rule Engine node and the Constant Value Column node Concatenate and join different data tables

Icon
06_​Data_​Aggregation_​Exercise

April 2020 · Solution to exercise 7 for the KNIME Analytics Platform for Data Wranglers course Calculate multiple aggregation using the Pivoting and GroupBy node Join grouped data Extract date fields from a DateTime value Handle missing values Manipulate strings Calculate new features using the Math Formula node

Icon
07_​Visualization_​Exercise

April 2020 · Exercise 8 for the KNIME Analytics Platform for Data Wranglers course Visualize the customer data using a scatter plot, a stacked area chart, and a bar chart Produce an interactive table using the Table View node Define a custom color for the data to plot Combine the visualizations into a composite…