How do I merge DataFrames in pandas?

If you want to combine multiple datasets into a single pandas DataFrame, you'll need to use the "merge" function. In this video, you'll learn exactly what happens during a merge operation, as well as how to use the four different types of joins. By the end of the video, you'll be fully prepared to merge your own DataFrames!

AGENDA:
0:00 Introduction
1:21 Selecting the correct function
3:36 Merging (joining) DataFrames
12:07 Handling common issues with merges
17:01 Comparing the four types of joins

RELATED VIDEOS:

WANT TO JOIN MY NEXT LIVE WEBCAST? Become a member ($5/month):

=== WANT TO GET BETTER AT PANDAS? ===

4) LET'S CONNECT!

[milindbebarta]

You are really good at explaining things. One of the better teachers on youtube. Thanks a ton for this video and I hope there's more coming.

[NoName-qxzc]

I'd like to thank the author. You really do a great job. Everything is structured, decomposed and coherent. Some guys just jump in complex coding without really explaining what's going on there.

[citizen_deb]

Thank you so much Kevin, your neat explanation along with the file you share makes it so clear, was really needing it!

[summerzhang]

Thanks for the videos Kevin! I love your teaching style and how you make each concept so crystal clear. Please keep making these videos! Just signed up to become a patron of yours and am taking your course on Data Camp (I wish you taught more courses on there!) Once I master Pandas will try out your machine learning course too :) ps your son is so adorable

[rawanfouda]

That was honestly really good! thank you so much for your work <3

[LuisRivera-celm]

I just wanted to thank you for such a great explanation of joins. I did not have it explained to me and struggled for the longest time to understand them. It takes a good teacher and someone who can understand it simply for one to understand it. Seriously, you are amazing!!

[mschuer]

This, by far, is the best explanation of these concepts. Thanks for sharing.

[lolkids]

Thanks, Kevin.. this is the clearest explanation of the merge I have seen.

[gregf]

Thank you so much for the concise clear explanation. Much appreciated.

[amrita]

This is one of the best ever videos on pandas functions that I have watched. Well done Data School. I will look forward to more such videos.

[CristianBittel]

Great as teacher, calm, taking your time to clearly explain fundamentals!

[jcbcorner]

Finally a clear explaination of merge function !! Thanks, subscribed

[da_ta]

Thanks Kevin I have been looking for this for long time!

[UrBigSisKey]

Really appreciate the work you put in for this video :) I've been working with dataframes for a few months, and this merge/join/concat always was a bit confusing for me. This video was perfect for clearing some of my doubts, and I'll definitely be back to reference again soon ;)

[lennysehs]

Your videos are fantastic. I really appreciate the simple "common sense" approach to the teaching. It is quite easy for instructors to dive right into python lingo.

[gardnmi]

The best new feature with merge is the validate option to make sure your join is 1:1, 1:M, etc. This is very useful for machine learning projects or end user reports that rely on upstream data that is updated regularly. It's saved me headaches a few times.

[pogoclub]

This is 1st time i walked into your video and i am very much impressed by your explaination and your english speaking pace is perfect. loved your content. Thanks a lot. :)

[DJoeyJordion]

This was a well-paced, clear and complete explanation of the topic, thank you very much! It helped me a lot <3

[hieungotrung]

Great to see you again as well as your high-quality content in your video

[Isabel-ecsq]

Thank you!! I finally got the dataframe I wanted!