What?
- A join is the operation of joining.
Joins can be classified by several criteria:
- is the information of data frame
y
included in the result? (mutating vs filtering joins) - what happens with non-matching rows? (inner vs outer joins / semi-join vs anti-join)
- how are key matching conditions defined? (equality vs inequality vs no restrictions)
- is the information of data frame