Icon

05 Date and Time Manipulation

Exercise for date and time manipulation.

Perform data manipulation operations that are specific to date and time values.

Exercise: Date&Time Manipulation1.1) Read the travel advisories data by executing the CSV Reader node below1.2) Convert the Accessed column in the travel advisory data from string to Date&time. What is thedate format in the string column? Notice that the data were accessed in October 2020.a) yyyy/mm/dd2.1) Read the life expectancy data by executing the Excel Reader node below2.2) Extract the year of the Accessed column in the life expectancy data into a separate column.Were all life expectancy data accessed in the same year?b) yes in 2020 demographics.xlsx(life_expectancy)Accessed columnto Date&Timetravel_advidories.csvOnly year Excel Reader String to Date&Time CSV Reader Extract Date&TimeFields Exercise: Date&Time Manipulation1.1) Read the travel advisories data by executing the CSV Reader node below1.2) Convert the Accessed column in the travel advisory data from string to Date&time. What is thedate format in the string column? Notice that the data were accessed in October 2020.a) yyyy/mm/dd2.1) Read the life expectancy data by executing the Excel Reader node below2.2) Extract the year of the Accessed column in the life expectancy data into a separate column.Were all life expectancy data accessed in the same year?b) yes in 2020 demographics.xlsx(life_expectancy)Accessed columnto Date&Timetravel_advidories.csvOnly year Excel Reader String to Date&Time CSV Reader Extract Date&TimeFields

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-09
On NodePit since: 2023-01-18
Last update: 2024-11-21
Created with KNIME version: v4.5.1
Tags: datetime

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

Try NodePit Runner!