Please enable JavaScript.
Coggle requires JavaScript to display documents.
Chapter 9: Data Integration (Joins: access more features (Joins used for…
-
Customer Info + Login Info #
Likely only one customer record and many customer behaviors #
lines up columns containing similar information on top of eachother #
Combine info from multiple databases #
-
-
-
Combines horizontally to the right and includes non-corresponding rows (nulls/non-purchases) #
Combines horizontally and includes to the left and includes non-corresponding rows (abandoned carts/near-purchases) #
Combines horizontally any order connected to a customer or not (Left and Right) #
collect as much data as possible #
Having aggregate of a person's information in a single system is critical to performing high-quality analysis and machine learning #
good with overlapping data #
good for additional data with no overlap #
assign average to every column with a missing value #