merge() Method to Join Multiple Pandas Dataframes - Beginner Python Pandas Tutorial #7

This is beginner Python Pandas tutorial #7 and in this video, we dive into the merge() method to join multiple Pandas dataframes together. We start with a simple example to explain the default behavior of the merge() method. Then we dive into the different parameters of the merge() method. First, we cover how to specify columns in the merge() method using different parameters related to the ‘on’ parameter like ‘left_on’ and ‘right_on’. Then we cover how to merge on indices using the ‘left_index’ and ‘right_index’. Last we cover the mixing the two parameters.

Documentation can be found here:

Let me know if you have any questions and please offer feedback on how I can improve to help you better.

If you enjoyed this video, please throw in a like and subscribe to my channel. I’ll be posting a lot more videos on data science concepts that cover all things python and SQL.

------------------------------------------
------------------------------------------
Follow along interactively and execute code with me as I walk through the concepts!

------------------------------------------

[saitejadidigam]

Man!!! Your tutorials are so unique, btw your SQL playlist is awesome, totally loved it.

[zahedinima]

This video is a real gem! It gives me an intuitive understanding of the merge method! I hope you'll create more videos!! 💌

[maximilianodelatorre]

Thank you so much for this!! very clrearly explained!!!

[_PraveenSingh_]

I wish I had found this playlist earlier, didn't know merge function in my previous interview. They asked me a question which was a combination of merge and groupby.
Thanks! for creating an amazing playlist.

[fadwa]

love this channel
it is great
Thank you so much