Icon

07 Join and Concatenate

05 Join and Concatenate

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.










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? Cols: 15 Rows: 32549And in the second? Cols: 16 Rows: 32549Were any rows discarded in the joining operations?No 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?adult_scotland is missing: id column If you want to include this column in your concatenated table, do you select union or intersection of columns?union 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? Cols: 15 Rows: 32549And in the second? Cols: 16 Rows: 32549Were any rows discarded in the joining operations?No 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?adult_scotland is missing: id column If you want to include this column in your concatenated table, do you select union or intersection of columns?union 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