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