Please enable JavaScript.
Coggle requires JavaScript to display documents.
Ch 9 (Observations (cases) (Signals (features/conditions)), Join (two data…
Ch 9
Observations (cases)
Signals (features/conditions)
Join
two data sets combined with a shared identity value
50 separate rows if 1 and 50
inner join
Most commonly used
Example:9.3
Inner join
By customer ID
Then join special orders by OrderID
1 more item...
Outer Join
Left outer join
Right outer join
Full outer join
Union
Multiple columns in common
Use union when you have unique sets of cases sharing the same or very similar columns
Full outer join is great if overlaps between rows and shared identifiers
no data overlaps but added data points, use union
Imputation (ex: put average age when age is missing)