Icon

05 Date and Time Manipulation

05 Date and Time Manipulation
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. 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? 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. 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? 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: 2022-01-22
Last update: 2024-05-01
Created with KNIME version: v4.5.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!