Icon

05 Data Visualization

05 Data Visualization
Exercise: Data Explorer1) Read the adult.csv file by executing the CSV Reader node2) Inspect the properties of the data with the Data Explorer node- How many different native countries are represented in the data? 39 countries. 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?native-country contains 583 missing values, occupation contains 1842 missing values, andworkclass contains 1835 missing valuesNote! 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? A slight positivecorrelation is observed- What can you say about the marital status of people who work <25 hours per week andcommute the most? People who work <25 hours a week and commute the longest are oftennever 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 adult.csvRead adult_w_commute.tableNode 32Node 33 CSV Reader Table Reader Data Explorer Color Manager Component Exercise: Data Explorer1) Read the adult.csv file by executing the CSV Reader node2) Inspect the properties of the data with the Data Explorer node- How many different native countries are represented in the data? 39 countries. 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?native-country contains 583 missing values, occupation contains 1842 missing values, andworkclass contains 1835 missing valuesNote! 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? A slight positivecorrelation is observed- What can you say about the marital status of people who work <25 hours per week andcommute the most? People who work <25 hours a week and commute the longest are oftennever 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 adult.csvRead adult_w_commute.tableNode 32Node 33CSV Reader Table Reader Data Explorer Color Manager 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: 2022-02-26
Last update: 2024-05-02
Created with KNIME version: v4.5.1
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!