Pandas For Beginners — Combining Dataframes — Part 2

Replicating SQL type joins using Pandas.

Photo by Janita Sumeiko on Unsplash

In the previous tutorial, we looked at the append and concat functions for combining dataframes. A limitation of using these functions is, they allow concatenation operations only based on row indexes or column names. If one has to join two dataframes on a specific column (the way we typically do in…