Icon

LAB 4 Part 1

Task 1: Date and Time Manipulation1. Read the New York City Airbnb data by executing the CSV Reader node2. Convert the timestamps in the last_review column from string to Date&Time3. Remove rows with missing values in the last_review column4. Remove the time values from the timestamps5. Extract the day of the week from each timestamp6. Count the number of last reviews on each day of the week Remove timeCount by weekdayRemove rows wherelast_review is missingExtract weekdayNode 43 String to Date&Time Modify Time GroupBy Sorter Missing Value Extract Date&TimeFields CSV Reader Task 1: Date and Time Manipulation1. Read the New York City Airbnb data by executing the CSV Reader node2. Convert the timestamps in the last_review column from string to Date&Time3. Remove rows with missing values in the last_review column4. Remove the time values from the timestamps5. Extract the day of the week from each timestamp6. Count the number of last reviews on each day of the week Remove timeCount by weekdayRemove rows wherelast_review is missingExtract weekdayNode 43String to Date&Time Modify Time GroupBy Sorter Missing Value Extract Date&TimeFields CSV Reader

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: lisah
Created at: 2023-03-10
On NodePit since: 2023-03-11
Last update: 2024-11-14
Created with KNIME version: v4.7.1

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

Try NodePit Runner!