Icon

01 Date and Time Manipulation

Exercise for date and time manipulation.

Transform date and time values from string to the dedicated Date&Time format. Remove redundant digits from the timestamps. Extract the day of the week from the dates, and aggregate the data.


Exercise: Date and Time ManipulationRead the New York City Airbnb data by executing the CSV Reader node.1) Convert the timestamps in the last_review column from string to Date&Time2) Remove rows with missing values in the last_review column3) Remove the time values from the timestamps4) Extract the day of the week from each timestamp5) Count the number of last reviews on each day of the week. Which day of theweek has the highest count? Sunday And the lowest? Thursday Read AB_NYC_2019dataconvert last_reviewto datetimeremove missinglast_reviewremove timevaluesextract day of the weekobtain countby day of theweeksort countdescendingremove missinglast_reviewremove timevaluesextract day of the weeksort countdescendingobtain countby day of theweek CSV Reader String to Date&Time Row Filter Modify Time Extract Date&TimeFields GroupBy Sorter Missing Value Modify Time Extract Date&TimeFields Sorter GroupBy Exercise: Date and Time ManipulationRead the New York City Airbnb data by executing the CSV Reader node.1) Convert the timestamps in the last_review column from string to Date&Time2) Remove rows with missing values in the last_review column3) Remove the time values from the timestamps4) Extract the day of the week from each timestamp5) Count the number of last reviews on each day of the week. Which day of theweek has the highest count? Sunday And the lowest? Thursday Read AB_NYC_2019dataconvert last_reviewto datetimeremove missinglast_reviewremove timevaluesextract day of the weekobtain countby day of theweeksort countdescendingremove missinglast_reviewremove timevaluesextract day of the weeksort countdescendingobtain countby day of theweekCSV Reader String to Date&Time Row Filter Modify Time Extract Date&TimeFields GroupBy Sorter Missing Value Modify Time Extract Date&TimeFields Sorter 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-23
On NodePit since: 2023-03-12
Last update: 2024-05-03
Created with KNIME version: v4.5.1
Tags: datetimestring to date&timemodify timeextract date&time fields

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

Try NodePit Runner!