Icon

07 Join and Concatenate

07 Join and Concatenate
Exercise: Concatenate1) Read the life expectancy data from two sources: an Excel sheet that contains the data for countries and adatabase table that contains the data for continents.2) Concatenate them into one table. Use union of columns. What happens to the Rank column that ismissing in the top table? Exercise: Join1) Read the population, life expectancy, geo coordinates, and travel advisories data by executing the readernodes below2) Join all tables based on the names of the countries. Use inner join. How many rows are there in the finaljoined table? Were any rows discarded during the joining operation?3) OPTIONAL: The names of the following countries are written differently in the travel advisories tablecompared to the other tables. The spelling in the other tables is shown in brackets:- The Gambia (Gambia)- Guinea Bissau (Guinea-Bissau)- The Bahamas (Bahamas)Edit the country names in the travel advisories table manually with the Table Editor node. Join the edited tablewith the other tables. How many rows are there in the joined table now? Demographics.sqliteLifeExpectancyInner join on country nameInner join on country nameManual manipulationLE for countriesand continentsInner join on country nametravel_advidories.csvgeo_coordinates.tabledemographics.xlsx(population)demographics.xlsx(life_expectancy)demographics.xlsx(life_expectancy) SQLite Connector DB Table Selector DB Reader Joiner Joiner Table Editor Concatenate Joiner File Reader Table Reader Excel Reader Excel Reader Excel Reader Exercise: Concatenate1) Read the life expectancy data from two sources: an Excel sheet that contains the data for countries and adatabase table that contains the data for continents.2) Concatenate them into one table. Use union of columns. What happens to the Rank column that ismissing in the top table? Exercise: Join1) Read the population, life expectancy, geo coordinates, and travel advisories data by executing the readernodes below2) Join all tables based on the names of the countries. Use inner join. How many rows are there in the finaljoined table? Were any rows discarded during the joining operation?3) OPTIONAL: The names of the following countries are written differently in the travel advisories tablecompared to the other tables. The spelling in the other tables is shown in brackets:- The Gambia (Gambia)- Guinea Bissau (Guinea-Bissau)- The Bahamas (Bahamas)Edit the country names in the travel advisories table manually with the Table Editor node. Join the edited tablewith the other tables. How many rows are there in the joined table now? Demographics.sqliteLifeExpectancyInner join on country nameInner join on country nameManual manipulationLE for countriesand continentsInner join on country nametravel_advidories.csvgeo_coordinates.tabledemographics.xlsx(population)demographics.xlsx(life_expectancy)demographics.xlsx(life_expectancy)SQLite Connector DB Table Selector DB Reader Joiner Joiner Table Editor Concatenate Joiner File Reader Table Reader Excel Reader Excel Reader Excel Reader

Nodes

Extensions

Links