pandas.DataFrame.merge¶ DataFrame.merge (self, right, how='inner', on=None, left_on=None, right_on=None, left_index=False, right_index=False, sort=False, suffixes=('_x', '_y'), copy=True, indicator=False, validate=None) → 'DataFrame' [source] ¶ Merge DataFrame or named Series objects with a database-style join. Advantages of pandas joins 100 xp Simple coding for complex merges 100 xp View Chapter Details Play Chapter Now. VLOOKUP-style joins In this chapter, you'll learn how to use pandas for joining data in a way similar to using VLOOKUP formulas in a spreadsheet. You'll learn about three types of joins and then focus on the first type, one-to-one joins. The join is done on columns or indexes.