Combining Data in Pandas With merge(), .join(), and concat()

Combining Data in pandas With concat() and merge()

Martin Breuss
Martin Breuss 20 Lessons 1h 34m intermediate data-science
Start Now Rate and Review

The Series and DataFrame objects in pandas are powerful tools for exploring and analyzing data. Part of their power comes from a multifaceted approach to combining separate datasets. With pandas, you can merge and concatenate your datasets, allowing you to unify and better understand your data as you analyze it.

In this video course, you’ll learn how and when to combine your data in pandas with:

  • merge() for combining data on common columns or indices
  • concat() for combining DataFrames across rows or columns

If you have some experience using DataFrame and Series objects in pandas and you’re ready to learn how to combine them, then this video course will help you do exactly that. If you’re feeling a bit rusty, then you can watch a quick refresher on DataFrames before proceeding.

What’s Included:

Downloadable Resources:

Related Learning Paths:

Start Now

Getting Started

3 Lessons 9m

  1. 1. Combining Data in pandas with concat() and merge() (Overview)03:22
  2. 2. Set Up Your Environment02:49
  3. 3. Create the Dataset03:09

Combining Data Using concat()

8 Lessons 31m

  1. 1. Concatenate Along the Row Axis03:33
  2. 2. Concatenate Along the Column Axis05:45
  3. 3. Mark Your DataFrames With Keys03:34
  4. 4. Access Data in a Multi-Index DataFrame04:45
  5. 5. Re-create a New Index After Concatenation03:47
  6. 6. Join Columns When Concatenating on Rows04:46
  7. 7. Join Rows When Concatenating on Columns02:36
  8. 8. Revisit Combining Data Using concat()02:32

Combining Data Using merge()

9 Lessons 53m

  1. 1. Perform an Inner Join Using merge()07:01
  2. 2. Perform an Outer Join Using merge()06:19
  3. 3. Understand the Differences Between Left and Right Joins07:34
  4. 4. Specify the Join Columns Explicitly06:07
  5. 5. Join DataFrames Using Index Columns06:48
  6. 6. Customize Column Suffixes and Perform a Cross Join04:12
  7. 7. Practice Your Intuition With Some Peculiarities07:10
  8. 8. Revisit Combining Data Using merge()03:23
  9. 9. Combining Data in pandas With concat() and merge() (Summary)04:51
Start Now

About Martin Breuss

Martin is Real Python's Head of Content Strategy. With a background in education, he worked as a coding mentor, code reviewer, curriculum developer, bootcamp instructor, and instructional designer.

» More about Martin

Each tutorial at Real Python is created by a team of developers so that it meets our high quality standards. The team members who worked on this tutorial are:

Christopher

Kate

Tappan

Kyle

Geir Arne

Joanna

Aldren

Bryan

Jacob

Related Courses:

Python's "in" and "not in" Operators: Check for Membership

Checking for Membership Using Python's "in" and "not in" Operators

Absolute vs Relative Imports in Python

Absolute vs Relative Imports in Python

Python 3 "pathlib" Module: Taming The Filesystem

Using Python's pathlib Module

← Browse All Courses