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.

Next, we cover different merge types by explaining the ‘how’ parameter and what the different values the ‘how’ parameter takes such as ‘inner’, ‘outer’, ‘left’, ‘right’. I would suggest you take a read on SQL JOINs to better understand the concepts dealing with the ‘how’ parameter (https://www.w3schools.com/sql/sql_join.asp).

Documentation can be found here:
Pandas merge: http://pandas.pydata.org/pandas-docs/stable/merging.html

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.

------------------------------------------
Subscribe to my channel: https://bit.ly/2WOgqil
------------------------------------------
Follow along interactively and execute code with me as I walk through the concepts!

Python notebook used in the video: https://bit.ly/2M2RjDr

Datasets can be found here: https://bit.ly/3gsZdUS

After watching the video, test yourself with our python exercises: https://bit.ly/2B50Jw8

Python exercises with solutions: https://bit.ly/3c3X2DL

Here’s help on how to run a python notebook using Google Colabs: https://bit.ly/2YXKR8o

Much of the content was adapted from the book and GitHub of Jake VanderPlas’s Python Data Science Handbook: https://jakevdp.github.io/PythonDataScienceHandbook/
------------------------------------------

Trying to improve your python skills or prepare for your next technical interview? Practice with over 500+ interactive python questions on a full-fledged coding workspace that requires no installation on Strata Scratch - https://www.stratascratch.com - and use the promo code ‘ss15’