How to combine DataFrames in Pandas | Merge, Join, Concat, & Append

In this video we go over how to combine DataFrames using merge, join, concat, and append. We also discuss the different join types and how to use them in pandas. It is explained how to stack DataFrames on top of one another and how to stich DataFrames together side-by-side.

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
$15 off Annual Dataquest subscription
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Did you find this video helpful? Consider subscribing for weekly tips, tricks, and tutorials.

Join my Discord Server

Reference: The Real Python

0:00 Intro
1:09 Merge (side-by-side)
6:40 Join Types
8:15 Merge Errors
9:55 Join
10:43 Concat (Stack)
12:48 Append

[ttolu]

The most simplified tutorial I’ve seen about this topic, now I understand perfectly. Putting all tables and codes in discussion side by side made it easy. Thank you 🙏🏾

[leongkern]

you just saved my final year project sir! Much respect for the concise and visual learning material

[manangoyal]

Amazing video! Wish I could like it 1000s of times myself.
Within 13 minutes, using rightly put graphics you've taught these 4 topics to me with such an ease, that's highly admirable!
Please keep making more videos, the world could use more people like you :D

[chrisbagshaw]

Ugh I have a deadline tomorrow and this video actually saved me

[hadidy]

Thanks so much!
The only detailed explanation on YouTube, every other tutorial just write the code and you should guess what really happened.

[anthimostsirigotis]

Thank you man!!! In just 12min I managed to understand everything. I follow you from now on!

[AlexFariaOliveira]

THANK YOU! I was days trying to merge 2 lists and was not finding a way your video made it all clear and half way though it I stopped and solved my problem!

[PeaceAction]

Very simple and easy to understand explanation, the concept has been explained in almost the first minute

[rolfbecker]

The explanations are easy to understand and comprehensive. Perfect! I will recommend your material to my students. Thank you!

[sashi]

Practical and concise explanation.
Enjoyed watching your learning videos

[hedibena]

I would like to thank you for sharing this knowledge in an incredible and such easy way! This really helped me, thanks a lot!

[manavsaxena]

Amazing content, I am more of a visual learner and you have explained the concepts brilliantly with examples. Please keep it coming, I am gonna binge watch all yours videos. Subscribed!

[PP-imlu]

Wow. I can't believe how clear this explanation is! It helped me a lot! Just one thing though. It seems the concat (inner) is not exactly the same as the merge (default). concat (inner) seems to just get rid of the rows or the columns with NaNs, but merge would make sure there are matching values (whereas concat (inner) doesn't).

[kamrulfst]

Thanks for your video about merge, concate method. Its more clear to me now.

[AnilAnvesh]

The best video on YouTube on #Python #Pandas
Gratitude for your efforts ❤️

[trustedai]

Excellent tutorial with lucid and simplified explanations.

[helengh]

Hi, I love the video, that was so clear and useful would you please explain what is the best way to merge and or concat the data frame which are not created in current working directory, should we read them one by one or is there any other short way?

[darkmatter]

thank you for making this video it really helped with my problem that i was stuck in, thank you.

[Puma_]

hi, I loved your video, very clear explanation and good example, thank you

[hoaralatoan]

Super clearly, a helpful explanation. Thank you so much.