Icon

01 Date and Time and Databases - Solution

There has been no title set for this workflow's metadata.

Date and Time and Databases - Exercise (Solution)

This workflow shows a solution to a hands-on exercise in the L2-DS Introduction to KNIME Analytics Platform for Data Scientists - Advanced course

URL: KNIME Self-Paced Courses https://www.knime.com/knime-self-paced-courses

Task 1: Date and Time Manipulation1)通过执行CSVReade节点读取纽约市Airbnb数据（房间入住数据包点评和最后浏览数据）2)将lastreview列中的时间戳从字符串转换为日期和时间(最后浏览日期和时间)3)删除last_review列中包含缺失值的行4)从时间戳中删除时间值5)每个时间戳中提取星期几6)统计一周内每一天最后一次评论的次数并排序备注：Name字段名称是 ARNBN公寓的名字 任务2:数据库数据操作1连接到“data”文件夹中的Accommodation.sqlite数据库2将ModifyTime节点提供的Airbnb数据写入数据库3.使用适当的DB节点执行以下数据操作任务:。计算每个邻里组的平均房价·将价格信息加入原始数据库表·将数据过滤到至少有一次点评的客房/公寓4.将连接的数据读入KNIME Remove timeCount by weekdayRemove rows wherelast_review is missingRead AB_NYC_2019dataExtract weekdayJoin to originaldataNumber of reviews> 0Read datainto KNIMEWriteAB_NYC_2019 tablePrice perneighborhood_groupRemove timeNode 51 String to Date&Time Modify Time GroupBy Sorter Missing Value CSV Reader Extract Date&TimeFields DB Joiner DB Row Filter DB Reader SQLite Connector DB Writer DB GroupBy Modify Time DB Table Selector Task 1: Date and Time Manipulation1)通过执行CSVReade节点读取纽约市Airbnb数据（房间入住数据包点评和最后浏览数据）2)将lastreview列中的时间戳从字符串转换为日期和时间(最后浏览日期和时间)3)删除last_review列中包含缺失值的行4)从时间戳中删除时间值5)每个时间戳中提取星期几6)统计一周内每一天最后一次评论的次数并排序备注：Name字段名称是 ARNBN公寓的名字 任务2:数据库数据操作1连接到“data”文件夹中的Accommodation.sqlite数据库2将ModifyTime节点提供的Airbnb数据写入数据库3.使用适当的DB节点执行以下数据操作任务:。计算每个邻里组的平均房价·将价格信息加入原始数据库表·将数据过滤到至少有一次点评的客房/公寓4.将连接的数据读入KNIME Remove timeCount by weekdayRemove rows wherelast_review is missingRead AB_NYC_2019dataExtract weekdayJoin to originaldataNumber of reviews> 0Read datainto KNIMEWriteAB_NYC_2019 tablePrice perneighborhood_groupRemove timeNode 51String to Date&Time Modify Time GroupBy Sorter Missing Value CSV Reader Extract Date&TimeFields DB Joiner DB Row Filter DB Reader SQLite Connector DB Writer DB GroupBy Modify Time DB Table Selector

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-23
On NodePit since: 2026-02-06
Last update: 2026-02-06
Created with KNIME version: v5.2.0
Tags: datetimestring to date&timemodify timeextract date&time fieldseducationdatabase

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

Try NodePit Runner!