Icon

02 Database Data Manipulation - Solution

Solution to an exercise for database data manipulation.

Write a local data table into a database. Aggregate, join, and filter the data on the database. Read the manipulated data back into KNIME.

CHECK YOUR ANSWERS:
38843 rooms out of the 49079 listed rooms have at least one review

Exercise: Database Data ManipulationRead the New York City Airbnb data by executing the metanode.1) Connect to the Accommodation.sqlite database available in the "data" folder2) Write the Airbnb data into the database. Create a table called AB_NYC_2019. Overwrite it if it existsalready.3) Perform the following data manipulation tasks with the appropriate DB nodes:- Calculate the average room price in each neighborhood group- Join the price information to the original database table- Filter the data to rooms/apartments with at least one review4) Read the joined and filtered data into KNIME. How many rooms/apartments have at least one review? WriteAB_NYC_2019 tablePrice perneighborhood_groupJoin to originaldataNumber of reviews> 0Read datainto KNIME SQLite Connector DB Writer DB GroupBy DB Joiner DB Row Filter DB Reader Read AB_NYC_2019 Exercise: Database Data ManipulationRead the New York City Airbnb data by executing the metanode.1) Connect to the Accommodation.sqlite database available in the "data" folder2) Write the Airbnb data into the database. Create a table called AB_NYC_2019. Overwrite it if it existsalready.3) Perform the following data manipulation tasks with the appropriate DB nodes:- Calculate the average room price in each neighborhood group- Join the price information to the original database table- Filter the data to rooms/apartments with at least one review4) Read the joined and filtered data into KNIME. How many rooms/apartments have at least one review? WriteAB_NYC_2019 tablePrice perneighborhood_groupJoin to originaldataNumber of reviews> 0Read datainto KNIMESQLite Connector DB Writer DB GroupBy DB Joiner DB Row Filter DB Reader Read AB_NYC_2019

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: 2023-09-25
Last update: 2024-11-05
Created with KNIME version: v4.4.0
Tags: databaseSQLite

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

Try NodePit Runner!