Skip to main content

Course

Joining Data with pandas

IntermediateSkill Level

4.8+

Updated 12/2025

Learn to combine data from multiple tables by joining data together using pandas.

Start Course for Free

PythonData Manipulation

4 hr

15 videos

51 Exercises

4,050 XP

210K+

Statement of Accomplishment

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Loved by learners at thousands of companies

Training a Team?

Try for Business

Course Description

Being able to combine and work with multiple datasets is an essential skill for any aspiring Data Scientist. pandas is a crucial cornerstone of the Python data science ecosystem, with Stack Overflow recording 5 million views for pandas questions. Learn to handle multiple DataFrames by combining, organizing, joining, and reshaping them using pandas. You'll work with datasets from the World Bank and the City Of Chicago. You will finish the course with a solid skillset for data-joining in pandas.The videos contain live transcripts you can reveal by clicking "Show transcript" at the bottom left of the videos.The course glossary can be found on the right in the resources section.To obtain CPE credits you need to complete the course and reach a score of 70% on the qualified assessment. You can navigate to the assessment by clicking on the CPE credits callout on the right.

What you'll learn

Concatenate and Manage DataFrame Integrity
Filter, Query, and Reshape Data for Analysis
Merge Using Index, Hierarchical, and Time-Series Structures
Perform and Customize DataFrame Joins

Feels like what you want to learn?

Start Course for Free

Prerequisites

Data Manipulation with pandas

1

Data Merging Basics

Learn how you can merge disparate data using inner joins. By combining information from multiple sources you’ll uncover compelling insights that may have previously been hidden. You’ll also learn how the relationship between those sources, such as one-to-one or one-to-many, can affect your result.

What column to merge on?

Your first inner join

Inner joins and number of rows returned

One-to-many relationships

One-to-many classification

One-to-many merge

Merging multiple DataFrames

Total riders in a month

Three table merge

One-to-many merge with multiple tables

2

Merging Tables With Different Join Types

Take your knowledge of joins to the next level. In this chapter, you’ll work with TMDb movie data as you learn about left, right, and outer joins. You’ll also discover how to merge a table to itself and merge on a DataFrame index.

Counting missing rows with left join

Enriching a dataset

How many rows with a left join?

Other joins

Right join to find unique movies

Popular genres with right join

Using outer join to select actors

Merging a table to itself

How does pandas handle self joins?

Merging on indexes

Index merge for movie ratings

Do sequels earn more?

3

Advanced Merging and Concatenating

In this chapter, you’ll leverage powerful filtering techniques, including semi-joins and anti-joins. You’ll also learn how to glue DataFrames by vertically combining and using the pandas.concat function to create new datasets. Finally, because data is rarely clean, you’ll also learn how to validate your newly combined data structures.

Filtering joins

Steps of a semi join

Performing an anti join

Performing a semi join

Concatenate DataFrames together vertically

Concatenation basics

Concatenating with keys

Verifying integrity

Validating a merge

Concatenate and merge to find common songs

4

Merging Ordered and Time-Series Data

In this final chapter, you’ll step up a gear and learn to apply pandas' specialized methods for merging time-series and ordered data together with real-world financial and economic data from the city of Chicago. You’ll also learn how to query resulting tables using a SQL-style format, and unpivot data using the melt method.

Using merge_ordered()

Correlation between GDP and S&P500

Phillips curve using merge_ordered()

merge_ordered() caution, multiple columns

Using merge_asof()

Using merge_asof() to study stocks

Using merge_asof() to create dataset

merge_asof() and merge_ordered() differences

Selecting data with .query()

Explore financials with .query()

Subsetting rows with .query()

Reshaping data with .melt()

Select the right .melt() arguments

Using .melt() to reshape government data

Using .melt() for stocks vs bond performance

Course wrap-up

Joining Data with pandas

Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance reviewEnroll Now

Don’t just take our word for it

*4.8

from 8,422 reviews

82%

17%

1%

0%

0%

Sort by

Yehor

2 hours ago

Kai-Min

3 hours ago

Jeffrey

8 hours ago

Complicated chapter but speaker and content made it easy to follow.

Emily

10 hours ago

Liuyi

10 hours ago

Priyansh

13 hours ago

Yehor

Kai-Min

"Complicated chapter but speaker and content made it easy to follow."

Jeffrey

FAQs

How long is the course?

The course typically takes about 4 hours to complete.

Will I receive a certificate at the end of the course?

Yes, upon successful completion of the course and the assessment, you will receive a DataCamp certificate.

What types of tables and data structures can I expect to learn to join with pandas?

You will learn to combine and work with multiple datasets, including one-to-one, one-to-many, left, right, and outer joins. You will also learn how to merge a table to itself and merge on a DataFrame index.

Who will benefit from this course?

This course is beneficial for aspiring data scientists, as it will equip them with the skills needed to effectively join data with pandas. Business analysts, financial analysts, and software engineers will also benefit from knowing how to join and reshape datasets with pandas.

Will I learn to join together time-series and ordered data?

Yes, you will learn to merge time-series and ordered data together with real-world financial and economic data.

Join over 19 million learners and start Joining Data with pandas today!

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Grow your data skills with DataCamp for Mobile

Make progress on the go with our mobile courses and daily 5-minute coding challenges.