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 the date format in the string column?Notice that the data were accessed in October 2020. 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 dataaccessed in the same year? In 2020 demographics.xlsx( life_expectancy)Accessed columnto Date&Timetravel_advidories.csvOnly yearExcel 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 the date format in the string column?Notice that the data were accessed in October 2020. 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 dataaccessed in the same year? In 2020 demographics.xlsx( life_expectancy)Accessed columnto Date&Timetravel_advidories.csvOnly yearExcel 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-03-09
Last update: 2024-05-01
Created with KNIME version: v4.7.0
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!