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
En esta página del sitio puede ver el video en línea Pretty Powerful Pandas - Merging DataFrames: SQL Meets Python de Duración hora minuto segunda en buena calidad , que subió el usuario Datacove 15 julio 2025, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 27 veces y le gustó 1 a los espectadores. Disfruta viendo!
