Icon

Solution 6 ( Data Explorer)

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 39 different native countries arerepresented in the data.The columns containing missing values:- native-country, 583- occupation, 1842- workclass, 1835 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? 1. Read the data 2. Data Inspection Using Data Explorer 1. Read the data 2. Assign Colors using Color Manager Inspect theproperties of the dataRead adult.csvRead adult_w_commute.tableColor bymarital statusNode 42Read adult_w_commute.table Inspect theproperties of the dataNode 45 Data Explorer CSV Reader Table Reader Color Manager Component Table Reader Data Explorer Bar Chart 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 39 different native countries arerepresented in the data.The columns containing missing values:- native-country, 583- occupation, 1842- workclass, 1835 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? 1. Read the data 2. Data Inspection Using Data Explorer 1. Read the data 2. Assign Colors using Color Manager Inspect theproperties of the dataRead adult.csvRead adult_w_commute.tableColor bymarital statusNode 42Read adult_w_commute.table Inspect theproperties of the dataNode 45 Data Explorer CSV Reader Table Reader Color Manager Component Table Reader Data Explorer Bar Chart

Nodes

Extensions

Links