Lesson 5.8 · Pro
FULL OUTER JOIN and joining on a range
Keep unmatched rows from both sides, and match rows by "close enough" instead of "equal".
In this lesson
- FULL OUTER JOIN keeps both sides
- COALESCE the key
- Join on a time window
Go Pro to read this lesson
Pro unlocks every lesson and practice problem in SQL, Python, pandas and NumPy, with answers and step-by-step explanations.