Icon

05 Data Visualization

05 Data Visualization - Solution
Exercise: Data Explorer1) Read the adult.csv file by executing the File Reader node2) Inspect the properties of the data with the Data Explorer node- How many different native countries are represented in the data?3) In the interactive view, exclude the nominal columns that contain missing values- Which of the nominal columns contain missing values? How many missing values each? Note! The Data Explorer node is part of the KNIME JavaScript Views (Labs) Extension Exercise: Scatter Plot and Composite 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 time- Do you observe any particular relationship between these two columns?- What can you say about the marital status of people who work <25 hours per week andcommute the most?4) Create an interactive table that displays the data. Use the Table View node.5) Encapsulate the Scatter Plot and Table View nodes into a component. Open thecomponent's interactive view.6) Switch to the mouse mode "Select" in the scatter plot view and select the data points with<25 working hours and >120 min commuting time7) Show only selected rows in the interactive table- What is the native country of the selected data points? Read data adult.csvColor bymarital statusRead adult_w_commute.table File Reader Data Explorer Color Manager Table Reader Component Exercise: Data Explorer1) Read the adult.csv file by executing the File Reader node2) Inspect the properties of the data with the Data Explorer node- How many different native countries are represented in the data?3) In the interactive view, exclude the nominal columns that contain missing values- Which of the nominal columns contain missing values? How many missing values each? Note! The Data Explorer node is part of the KNIME JavaScript Views (Labs) Extension Exercise: Scatter Plot and Composite 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 time- Do you observe any particular relationship between these two columns?- What can you say about the marital status of people who work <25 hours per week andcommute the most?4) Create an interactive table that displays the data. Use the Table View node.5) Encapsulate the Scatter Plot and Table View nodes into a component. Open thecomponent's interactive view.6) Switch to the mouse mode "Select" in the scatter plot view and select the data points with<25 working hours and >120 min commuting time7) Show only selected rows in the interactive table- What is the native country of the selected data points? Read data adult.csvColor bymarital statusRead adult_w_commute.tableFile Reader Data Explorer Color Manager Table Reader 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: 2021-06-18
Last update: 2024-11-18
Created with KNIME version: v4.3.2
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!