Icon

extra 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?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? Slight positive correlation between hoursper week and commuting timePeople who work <25 hours per week andcommute > 120 min per day have themarital status "never married"Native country = United States Inspect data properties Color bymarital statusTelco Customer Churn .csvRead adult_w_commute.tableData Explorer Color Manager Component CSV Reader Table Reader 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?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? Slight positive correlation between hoursper week and commuting timePeople who work <25 hours per week andcommute > 120 min per day have themarital status "never married"Native country = United States Inspect data properties Color bymarital statusTelco Customer Churn .csvRead adult_w_commute.tableData Explorer Color Manager Component CSV Reader Table Reader

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-27
Last update: 2024-05-01
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!