Please enable JavaScript.
Coggle requires JavaScript to display documents.
Chapter 9: Data Integration (9.2 Unions (Ex (Training and Test Cases…
Chapter 9: Data Integration
Join
Combines two datasets with a shared value
Union
Based on assumption that there are multiple columns in common
9.1 Joins
Inner Join
Left row combined with right
With same identity
Outer Join
Left
Same as inner
Adds rows from left that do not have corresponding right rows
Right
Same as Inner
Adds rows from right table that do not correspond with the left
Full
Same as all of the below
Based on relational algebra
9.2 Unions
Allow to combine two datasets
(T) Top
(B) Bottom
Great for connecting different lists
No overlap just addition
Ex
Training and Test Cases
Train to train models
Test Case to rate the professor
Integrate both data sets