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? 40 countries3) 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 (583 missing values)* workclass (1835 missing values)* occupation (1842 missing values)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?* There is a slight positive correlation between "hours per week" and "commute time".- What can you say about the marital status of people who work <25 hours per week andcommute the most? These individuals have a "never-married" marital status.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? All four individuals are from the UnitedStates. Read adult.csvRead adult_w_commute.tableinspect the propertiesof the datacolor bymarital statusscatter plotand table view CSV Reader Table Reader Data Explorer Color Manager interactivecomponent 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? 40 countries3) 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 (583 missing values)* workclass (1835 missing values)* occupation (1842 missing values)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?* There is a slight positive correlation between "hours per week" and "commute time".- What can you say about the marital status of people who work <25 hours per week andcommute the most? These individuals have a "never-married" marital status.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? All four individuals are from the UnitedStates. Read adult.csvRead adult_w_commute.tableinspect the propertiesof the datacolor bymarital statusscatter plotand table viewCSV Reader Table Reader Data Explorer Color Manager interactivecomponent

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-24
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!