Icon

04 Visualization - Solution

Visualization - Exercise (Solution)

This workflow shows a solution to a hands-on exercise in the L1-DS Introduction to KNIME Analytics Platform for Data Scientists - Basics course

Task 1: Data Explorer1. Read the adult.csv file by executing the CSV Reader node2. Inspect the properties of the data with the Data Explorer node3. Exclude the nominal columns that contain missing values in its interactive view Note! The Data Explorer node is part of the KNIME JavaScript Views (Labs) Extension Task 2: Scatter Plot and Table View1. Read the adult_w_commute.table file by executing the Table Reader node2. Assign colors to the rows based on the marital status3. Draw a scatter plot of hours per week vs. commute time4. Create an interactive table that displays the data. Use the Table View node. Task 3: Interactive Dashboard1. Encapsulate the Scatter Plot and Table View nodes into a component. Open thecomponent's interactive view.2. Switch to the mouse mode "Select" in the scatter plot view and select the data points with<25 working hours and >120 min commuting time3. Show only selected rows in the interactive table Inspect theproperties of the dataColor bymarital statusRead adult.csvRead adult_w_commute.tableGroupBy marital statusNode 36 Data Explorer Color Manager CSV Reader Table Reader GroupBy InteractiveTable (local) Component Task 1: Data Explorer1. Read the adult.csv file by executing the CSV Reader node2. Inspect the properties of the data with the Data Explorer node3. Exclude the nominal columns that contain missing values in its interactive view Note! The Data Explorer node is part of the KNIME JavaScript Views (Labs) Extension Task 2: Scatter Plot and Table View1. Read the adult_w_commute.table file by executing the Table Reader node2. Assign colors to the rows based on the marital status3. Draw a scatter plot of hours per week vs. commute time4. Create an interactive table that displays the data. Use the Table View node. Task 3: Interactive Dashboard1. Encapsulate the Scatter Plot and Table View nodes into a component. Open thecomponent's interactive view.2. Switch to the mouse mode "Select" in the scatter plot view and select the data points with<25 working hours and >120 min commuting time3. Show only selected rows in the interactive table Inspect theproperties of the dataColor bymarital statusRead adult.csvRead adult_w_commute.tableGroupBy marital statusNode 36Data Explorer Color Manager CSV Reader Table Reader GroupBy InteractiveTable (local) Component

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Maarit Laukkanen
Created at: 2020-04-20
On NodePit since: 2023-01-24
Last update: 2024-11-21
Created with KNIME version: v4.7.0
Tags: data explorerinteractive viewcomposite viewscatter plotdashboardtable view

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!