Pandas functions: merge vs. join vs. concat

Pandas is very useful but sometimes it could be hard to understand the differences between some functions that work towards similar goals. In this video, let's see how merge, join and concat works and what their differences are.

RESOURCES:

COURSES:

[misraturp]

Which Pandas functions would you like me to compare/explain next?

[mosama]

Do you know what I really LOVE about your videos, you COVER THE WHOLE TOPIC, so if we talking about reshaping for example you mentioned all the 8 functions could be used and then you chose. Having the full picture really helps a lot. Even if you are an expert, going back to your videos, sometimes help remind us what other options do we have, or what other functions we might forget about.

[mosama]

Thank you for the beautiful videos, I'd just appreciate if you added a link to the data set and the notebook you use for each video please, so we can follow up with you.
Thanks a million again for the beautiful videos 🙂

[bethuelthipe-moukangwe]

The lessons about pandas are now making sense to me, especially on how to use groupby, apply, apply map and lambda function.
Big thanks Ms Misra Turp.

[kentjordan]

May you provide the dataset? Thanks! 😄

[oscar-expertprojectmanager]

Thank you Misra. Great explanation on the Pandas functions: merge vs. join vs. concat. One comment I would make about using pd.set_options('display.max_rows', None) and pd.set_options('display.max_columns', None); If your dataset is large, you run the risk of crushing your notebook, and you would have to go through a process to fix it.

[Xirato]

Thank you for your clear explanations! I love it how you explain it while using a simple example and go through it step by step. I’m new to Python and Pandas library and while looking up different functions the explanations can be a little bit overwhelming. You made this noobie prove! Keep up the good work and much appreciated!

[gaganbhattacharya]

I didn't know what does ''left_on & right_on' means in merge & the difference between merge & join but now I understand!
Thanks!

[harishpoalampalli]

Hey Turp !! great explanantion !! Is it possibe to provide the data sets !! Thanks

[zulhishamtan]

Thank you for the sharing... Awesome... I learnt a lot...

[SESHUNITR]

loved it Misra. clear explanation and a quick reference if we forget.

[ahmedalhomeidy]

clear explanation and precise and on to the point, I love it

[khemrajpatil]

Thanks for the vide!. It gives me clarity.

[loordgo]

thanx for the video. what about Merge Conflict? can be detected using Pandas?

[domillima]

When you merge left_on='ID', right_on='ID2'.. two columns of different names with the same IDs, is there a way to drop one of these, other than adding .dop(col_name) at the end? thanks

[mariaclaraceballos]

thanks for the explanation! what happens if we use the function concat with 2 dataframes that have repeated data, i mean an ID that is in both dataframes?

[vaibhavk]

In streamlit can you implement direction feature like we have in google maps i.e. we choose our starting point and ending point and and there is a direction showing the way

[Maryj]

Hi can you please help to do pivot with multiple sheets

[bryan-]

I never got sent any of the cheat sheets. Are you sure that links is still functioning?

[busrauygun]

Videolarınıza Türkçe altyazı ekleseniz Türkler de bu nimetten faydalansa çok güzel olmaz mı