This article is part of a series of practical guides for using the Python data processing library pandas. To see view all the available parts, click here.
One of the most fundamental concepts in data science and data work in general is joining two tables together based on some shared column or index. In SQL it is a JOIN
. In Excel it is INDEX-MATCH
or VLOOKUP
. In pandas, two methods are available to join tables together: merge
and join
. We will look at both of those methods in this guide.