Joining and Merging Dataframes - p.6 Data Analysis with Python and Pandas Tutorial

Welcome to Part 6 of the Data Analysis with Python and Pandas tutorial series. In this part, we're going to talk about joining and merging dataframes, as another method of combining dataframes. In the previous tutorial, we covered concatenation and appending.

[Mcsweeny]

"You sure can there little student!"

[jackjacky]

Thank you @sentdex. These are high quality, crystal clear tutorials.

[necuo]

I've been reading pandas documentation to find the difference between concat, merge and join. Your explanation is very clear, thanks! (I didn't understand the documentation entirely)

[OttoFazzl]

Great explanation on merging and the four "hows"! Merging and joining is one of the most important skills for basic data handling in data analysis. Please keep going!

[tymothylim]

Thank you very much for this video! I enjoyed you going through a mini-example and working with different parameter settings (i.e. inner, outer, left, right) for the type of join!

[justusgraham]

In a future video update, could you provide an example of join at the end to demonstrate how the indices are handled differently than merge when there's data duplication? Thanks!

[oksdotnet]

Hi Harrison, I religiously watch your tutorials. They're very detailed and works for all levels of understanding.
I come from a SAS data engineering background. And for me SAS macros to write reusable code is very handy. I know there's ways to do that with python functions. But it would be great if you could do a tutorial to create user defined functions to work with dataframes in pandas.
Thanks again.

[badugi]

I love you dude. You are the greatest!

[joestarks]

Hi Sentdex, thanks for the videos!
I was wondering; as neither dataframe nor list objects have .encode as an attribute, how can I best .encode(utf-8) a dataframe containing non-ascii characters so that it displays properly?

[himanshuladia]

Why is there even a duplication taking place? Basically, i am not able to understand merging based on 2 keys. Any help would be appreciated. I'm a newbie.

[ronenfischer]

You are simply the best. Very easy and coherent. My teacher copies your tutorials => you are the real deal. Good job man

[parthify]

Beautiful!!! Exactly what I needed. Thanks alot.

[TheChuckwagonLite]

I'm still new at Python. been watching you channel for a while now. wondered if there was a way to idk incorporate lighting when you accomplish something. sort of like an arcade machine with flashing lights.

[arindamkundu]

Thank you so sooo much. You rock !!! -

[NatHarwood]

Fantastic. Was really chuffed you covered merging (joining) on an index - with all my data being time series (i.e. 'Date' as the index), this is exactly what I need!

By the way, the plural of 'index' is 'indices' ;)

[irtazaa]

This is great ! I was confused with merge and hiearchichal indexes.. Thanks man

[connorvandersnick]

Great videos! Thank you for the awesome course!

[cyl]

you have done awesome job! thank you so much!!!

[Yourinnervibemusic]

Rock star!!! Great info, thanks for having such a big brain and sharing :)

[vishnu]

Its great to know Merge on dataframes. In one of my requirement I tried merging 2 datasets from 2 different sources( sybase & Oracle) which has nearly 60k records each. While applying merge it throws memory exception. I'm using outer join to identify the records which are available in Sybase and not loaded in oracle. Would you be able to recommend something to fix this memory error?