Icon

05 Date and Time Manipulation - Solution

Solution to an exercise for date and time manipulation.

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

CHECK YOUR ANSWERS:
1. The date format is yyyy/MM/dd
2. All life expectancy data were accessed in 2020


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.2.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? 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.2.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? 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-09-25
Last update: 2024-11-05
Created with KNIME version: v4.4.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!