Course
Joining Data with pandas
IntermediateSkill Level
Updated 12/2025PythonData Manipulation4 hr15 videos51 Exercises4,050 XP210K+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 2 or more people?
Try DataCamp for BusinessCourse Description
Feels like what you want to learn?
Start Course for FreeWhat 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
Prerequisites
Data Manipulation with pandas1
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.
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.
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.
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.
Joining Data with pandas
Course Complete
Earn Statement of Accomplishment
Add this credential to your LinkedIn profile, resume, or CVShare it on social media and in your performance reviewEnroll Now
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.