Icon

07 Join and Concatenate - Solution

Solution to an exercise for joining and concatenating data.

Combine data tables side-by-side using the join operation. Put tables on top of each other with the concatenate operation.

CHECK YOUR ANSWERS:

Joiner:
The number of rows is 32549 in all joined tables. No rows were discarded in the joining operations.

Concatenate:
The ID column is missing in the adult_scotland table. You need to select union of columns, if you want to include the ID column in the concatenated table.









Exercise: Joiner1) Read the adult.csv, adult_education.table, and adult_income.xlsx files by executing the reader nodes2) Join the adult.csv data with the adult_education.table data. Use the ID column as the joining column. Useinner join. 3) Join the adult_income.xlsx data with the joined table. Apply the same settings. 4) What is the number of rows and columns in the first joined table? And in the second? Were any rowsdiscarded in the joining operations? Exercise: Concatenate1) Execute the Table Reader nodes below. The adult_joined.table file contains the records for all countriesbut Scotland. The records for Scotland are stored in a separate adult_scotland.table file.2) Concatenate the two tables into one3) Which column is missing in one of the tables? If you want to include this column in your concatenatedtable, do you select union or intersection of columns? Read data adult.csvRead data adult_education.tableadult_joined.tableadult_scotland.tableRead dataadult_income.xlsx File Reader Table Reader Joiner Joiner Table Reader Table Reader Concatenate Excel Reader Exercise: Joiner1) Read the adult.csv, adult_education.table, and adult_income.xlsx files by executing the reader nodes2) Join the adult.csv data with the adult_education.table data. Use the ID column as the joining column. Useinner join. 3) Join the adult_income.xlsx data with the joined table. Apply the same settings. 4) What is the number of rows and columns in the first joined table? And in the second? Were any rowsdiscarded in the joining operations? Exercise: Concatenate1) Execute the Table Reader nodes below. The adult_joined.table file contains the records for all countriesbut Scotland. The records for Scotland are stored in a separate adult_scotland.table file.2) Concatenate the two tables into one3) Which column is missing in one of the tables? If you want to include this column in your concatenatedtable, do you select union or intersection of columns? Read data adult.csvRead data adult_education.tableadult_joined.tableadult_scotland.tableRead dataadult_income.xlsx File Reader Table Reader Joiner Joiner Table Reader Table Reader Concatenate Excel Reader

Nodes

Extensions

Links