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
CODE FROM THIS VIDEO: https://github.com/justmarkham/pandas-videos/blob/master/pandas_merge.ipynb
RELATED VIDEOS:
Using the pandas index (Part 1): https://www.youtube.com/watch?v=OYZNk7Z9s6I&list=PL5-da3qGB5ICCsgW1MxlZ0Hq8LL5U3u9y&index=17
Using the pandas index (Part 2): https://www.youtube.com/watch?v=15q-is8P_H4&list=PL5-da3qGB5ICCsgW1MxlZ0Hq8LL5U3u9y&index=18
WANT TO JOIN MY NEXT LIVE WEBCAST? Become a member ($5/month):
https://www.patreon.com/dataschool
=== WANT TO GET BETTER AT PANDAS? ===
1) WATCH my pandas video series: https://www.youtube.com/playlist?list=PL5-da3qGB5ICCsgW1MxlZ0Hq8LL5U3u9y
2) SUBSCRIBE for more videos: https://www.youtube.com/dataschool?sub_confirmation=1
3) ENROLL in my pandas course: https://www.datacamp.com/courses/analyzing-police-activity-with-pandas?tap_a=5644-dce66f&tap_s=280411-a25fc8
4) LET'S CONNECT!
- Newsletter: https://www.dataschool.io/subscribe/
- Twitter: https://twitter.com/justmarkham
- Facebook: https://www.facebook.com/DataScienceSchool/
- LinkedIn: https://www.linkedin.com/in/justmarkham/