Icon

05 Date and Time and Databases

Task 1: Convert a string column to Date&Time1. Read the travel advisories data by executing the provided CSV Reader node2. Convert the Accessed column in the travel advisory data from string to Date&Time Task 2: Extract year from timestamps1. Read the life expectancy data by executing the provided Excel Reader node2. Extract the year of accessing the data into a separate column There is no excel file with a date or timedata column in the files that you gave usin the Airports zip folder. There is no excel file with a date or timedata column in the files that you gave usin the Airports zip folder. Task 3: Manipulate data in database1. Execute the provided metanode. It writes the joined table containing demographics,travel advisory, and geo coordinates information into one SQLite database table. 2. Select the JoinedTable table in the database3. Calculate the number of rows (countries) in the database table4. Filter the table to countries where the overall life expectancy is greater than 80 years5. Calculate the number of these countries in each travel risk category There wasnt any files in the airports folder to create an SQLite file AirportsNode 2Node 4AirportsAirportsBy country nameAltitude above 10,000Max AltitudesCSV Reader String to Date&Time Extract Date&TimeFields CSV Reader CSV Reader GroupBy Row Filter GroupBy Task 1: Convert a string column to Date&Time1. Read the travel advisories data by executing the provided CSV Reader node2. Convert the Accessed column in the travel advisory data from string to Date&Time Task 2: Extract year from timestamps1. Read the life expectancy data by executing the provided Excel Reader node2. Extract the year of accessing the data into a separate column There is no excel file with a date or timedata column in the files that you gave usin the Airports zip folder. There is no excel file with a date or timedata column in the files that you gave usin the Airports zip folder. Task 3: Manipulate data in database1. Execute the provided metanode. It writes the joined table containing demographics,travel advisory, and geo coordinates information into one SQLite database table. 2. Select the JoinedTable table in the database3. Calculate the number of rows (countries) in the database table4. Filter the table to countries where the overall life expectancy is greater than 80 years5. Calculate the number of these countries in each travel risk category There wasnt any files in the airports folder to create an SQLite file AirportsNode 2Node 4AirportsAirportsBy country nameAltitude above 10,000Max AltitudesCSV Reader String to Date&Time Extract Date&TimeFields CSV Reader CSV Reader GroupBy Row Filter GroupBy

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: sammg
Created at: 2023-01-22
On NodePit since: 2023-01-22
Last update: 2024-05-03
Created with KNIME version: v4.7.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!