Icon

04 Components

04 Components
Exercise: ComponentsRead the New York City Airbnb data by executing the CSV Reader node. Create a component that filters the data by maximum price and neighborhood group:1.1) Create a Value Selection Configuration node to select one neighborhood group in the data1.2) Filter the data based on the selected neighborhood group1.3) Create an Integer Configuration node to select the maximum price per night1.4) Filter the data to the rooms below or equal to this price per night. Notice that you need to type anynumber in the upper bound field in order to make the configuration option appear in the Flow Variablestab. 1.5) Encapsulate the configuration nodes and Row Filter node into a component. Make sure that yourcomponent has a data output port that provides the filtered data! How many rooms are available inManhattan for maximum $50 per night? 3581Apply data cleaning steps in an interactive view:2.1) Drag and drop the Interactive Data Cleaning component from the KNIME Hub or from the EXAMPLESServer2.2) Connect it to the File Reader node, execute, and open its interactive view2.3) Apply automatic type guessing, remove rows with missing values, and remove duplicate rows. ClickApply and Close. Read AB_NYC_2019dataSelect max priceFilter by maximum priceSelect neighborhoodgroupFilter by neighborhoodNode 59 InteractiveData Cleaning CSV Reader IntegerConfiguration Row Filter Value SelectionConfiguration Row Filter Component Output Filter by neighborhoodgroup and maximum price File Reader Exercise: ComponentsRead the New York City Airbnb data by executing the CSV Reader node. Create a component that filters the data by maximum price and neighborhood group:1.1) Create a Value Selection Configuration node to select one neighborhood group in the data1.2) Filter the data based on the selected neighborhood group1.3) Create an Integer Configuration node to select the maximum price per night1.4) Filter the data to the rooms below or equal to this price per night. Notice that you need to type anynumber in the upper bound field in order to make the configuration option appear in the Flow Variablestab. 1.5) Encapsulate the configuration nodes and Row Filter node into a component. Make sure that yourcomponent has a data output port that provides the filtered data! How many rooms are available inManhattan for maximum $50 per night? 3581Apply data cleaning steps in an interactive view:2.1) Drag and drop the Interactive Data Cleaning component from the KNIME Hub or from the EXAMPLESServer2.2) Connect it to the File Reader node, execute, and open its interactive view2.3) Apply automatic type guessing, remove rows with missing values, and remove duplicate rows. ClickApply and Close. Read AB_NYC_2019dataSelect max priceFilter by maximum priceSelect neighborhoodgroupFilter by neighborhoodNode 59InteractiveData Cleaning CSV Reader IntegerConfiguration Row Filter Value SelectionConfiguration Row Filter Component Output Filter by neighborhoodgroup and maximum price File Reader

Nodes

Extensions

Links