Icon

05 Date and Time Manipulation

05 Date and Time Manipulation - Solution
Exercise: Date&Time Manipulation1.1) Read the travel advisories data by executing the File 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&TimeOnly yeartravel_advidories.csv Excel Reader String to Date&Time Extract Date&TimeFields File Reader Exercise: Date&Time Manipulation1.1) Read the travel advisories data by executing the File 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&TimeOnly yeartravel_advidories.csv Excel Reader String to Date&Time Extract Date&TimeFields File Reader

Nodes

Extensions

Links