Icon

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.














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?413) In the interactive view, exclude the nominal columns that contain missing values- Which of the nominal columns contain missing values? Native-country, occupation, workclassHow many missing values each? 583, 1843, and 1836Note! 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?Positive Correlation- What can you say about the marital status of people who work <25 hours per week andcommute the most?They have never married4) 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?United States Read data adult.csvNode 16marital status color codedRead 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?413) In the interactive view, exclude the nominal columns that contain missing values- Which of the nominal columns contain missing values? Native-country, occupation, workclassHow many missing values each? 583, 1843, and 1836Note! 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?Positive Correlation- What can you say about the marital status of people who work <25 hours per week andcommute the most?They have never married4) 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?United States Read data adult.csvNode 16marital status color codedRead 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: 2023-08-28
Last update: 2024-11-21
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!