Pretty Powerful Pandas - Merging DataFrames: SQL Meets Python
In this episode of Pretty Powerful Pandas, we dive into one of the most essential skills in real-world data analysis: joining tables.
Using the Global Superstore dataset, I walk through how to:
Load multiple sheets from Excel
Merge two real tables (Orders + Returns) using .merge()
Handle column conflicts (like Region_x and Region_y)
Fill in missing values
And most importantly — use that merged data to uncover insights like total profit lost from returns and most frequently returned products.
If you’re used to SQL joins or Excel VLOOKUPs, this is how you bring that logic into your Python workflow — all in one tidy script.
---------------------------------------------------------------------
We are Datacove, your data and analytics partner.
https://www.datacove.co.uk
Please hit the 'subscribe' button to make sure you never miss our free learning material here.
Want more in-depth learning resources? Book one of our training courses or join us at the EARL conference in Brighton - details of that and all our other socials can be found at https://linktr.ee/datacove
For business enquiries, please contact admin@datacove.co.uk
Sur cette page du site, vous pouvez voir la vidéo en ligne Pretty Powerful Pandas - Merging DataFrames: SQL Meets Python durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Datacove 15 juillet 2025, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 27 fois et il a aimé 1 téléspectateurs. Bon visionnage!
