Combine Data Sets Flashcards
1
Q
Join matching rows from bdf to adf.
A
2
Q
Join matching rows from adf to bdf.
A
3
Q
Join data. Retain only rows in both sets.
A
4
Q
Join data. Retain all values, all rows.
A
5
Q
all rows in adf that have a match in bdf
A
6
Q
all rows in adf that do not have a match in bdf
A
7
Q
Rows that appear in both ydf and zdf (Intersection).
A
8
Q
Rows that appear in either or both ydf and zdf (Union).
A
9
Q
Rows that appear in ydf but not zdf (Setdiff).
A
