Icon

04 Components

04 Components
Exercise: ComponentsRead the New York City Airbnb data by executing the File 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 in Manhattan for maximum $50 per night? 314 Apply 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_2019Node 56 InteractiveData Cleaning File Reader Component GroupBy Exercise: ComponentsRead the New York City Airbnb data by executing the File 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 in Manhattan for maximum $50 per night? 314 Apply 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_2019Node 56 InteractiveData Cleaning File Reader Component GroupBy

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-10-26
On NodePit since: 2021-06-30
Last update: 2024-04-26
Created with KNIME version: v4.3.2
Tags: configurationflow variablecomponentshared

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!