How to merge pandas DataFrame explained with SQL joins and cheat sheet: FULL OUTER JOIN, INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN.