Power Query vs. Python - Soccer Data Cleaning Challenge ⚽🥅
By Chandoo
Community Score: 50% | 128 views | 1mo
0 community ratings: null thumbs up, null thumbs down
Master this data cleaning challenge using real World Cup soccer statistics. Learn how to fix messy, multi-line goal entries to a neat table (or data frame). This tutorial walks you through a practical data cleaning challenge where I address a common issue: multiple goals recorded in a single cell separated by new line characters. This is essential knowledge for anyone looking to clean data efficiently. I am showing both Python & Power Query approaches for cleaning the data. Which one is your favourite? Comment and let me know. 📁 Try it yourself: Grab the raw data here and try it yourself - https://chandoo.org/wp/wp-content/uploads/2026/06/fifa-worldcup-goals-cleanup.xlsx 👩💻🧑💻 Completed code: See my github repo for the python notebook and PQ workbook. Python notebook: https://github.com/chandoo-org/python/blob/ba747ec6c5373c34ee35826d6a1c6822c42bae0f/fifa%20goals%20data%20cleanup.ipynb Power Query File: https://chandoo.org/wp/wp-content/uploads/2026/06/fifa-goals-pq.xlsx
Tags: chandoo, chandoo.org, Excel, spreadsheets, data cleaning challenge, excel data cleaning, soccer data analysis, data preparation, clean messy data, world cup data, data cleaning in excel, pandas data cleaning, pandas tutorial, power query data cleaning
More from Chandoo
- 20 AI Terms Explained in Plain English in 20 minutes 🕓 — Score: 50%
- Learn Advance Excel Formulas in an Hour - FREE Masterclass — Score: 50%
- 5 HR KPIs Every Analyst Needs to Master #HRAnalytics #KPIs — Score: 50%
- This simple Excel trick saves me hours on MIS reports 💡 — Score: 50%
- End to End Power Query Data Cleaning Masterclass [FREE Workbook] — Score: 50%
- Here is why I think Excel skills are still relevant in the age of AI — Score: 50%