join – Page 20 – Make Me Engineer

What is the difference between “INNER JOIN” and “OUTER JOIN”?

April 14, 2022 by Tarik

Assuming you’re joining on columns with no duplicates, which is a very common case: An inner join of A and B gives the result of A intersect B, i.e. the inner part of a Venn diagram intersection. An outer join of A and B gives the results of A union B, i.e. the outer parts … Read more

Pandas Merging 101

April 12, 2022 by Tarik

This post aims to give readers a primer on SQL-flavored merging with Pandas, how to use it, and when not to use it. In particular, here’s what this post will go through: The basics – types of joins (LEFT, RIGHT, OUTER, INNER) merging with different column names merging with multiple columns avoiding duplicate merge key … Read more