Excel vs Python for Data Cleaning

*NEW* Want my FREE Excel for Analytics Ultimate Guide including all the key shortcuts and functions shown in this series as well as in my Analytics Career Access program? Grab it here: https://www.tmbanalytics.com/download-your-guide-timeline-yt We’re all used to hearing the never-ending debates over Python vs R…but what about Excel? Well, this is the Excel vs Python for Data Cleaning comparison video. After repeatedly being asked “why don’t you just use Python?” in response to so many of my Excel tutorials, either on Linkedin, here on YouTube, or even on Reddit, I finally decided to answer the question the best way I could fathom – a data cleaning collaboration! In this video I have joined forces with the great Bradon Valgardson from the awesome channel @Chart Explorers, to take up the question and work through a realistic data cleaning exercise using both tools. Bradon uses his fancy Jupyter notebook and leverages the Pandas and Numpy libraries to execute his data cleaning effort in Python, while I leaned exclusively on PowerQuery in Excel. The results were very, very close and each tool has it’s respective strengths and weaknesses. If you want to see who came out on top you’ll have to check out the video and stick around to the end when Bradon and I sit down together and hash out our experiences in the exercise. If you want to follow along with the data cleaning exercise either using Python or PowerQuery you can access the source file here: 👉🏼 https://www.tmbanalytics.com/excel-for-analytics Also, if you wanted to check out the full, four-part Excel for Analytics Project Series I have the whole thing in a playlist right here: 👉🏼 https://youtube.com/playlist?list=PL_WHfGYyPRuOWqablvZAw3iJHUoIGk7F3 If you’re interested in a career in Analytics please consider checking out my free Analyst Career Foundations mini-course at: 👉🏼 https://www.tmbanalytics.com/freetraining And if you want to check out the Chart Explorers Discord Server you can find that here: 👉🏼 https://discord.gg/EEajBNpeK9 Here’s how the Excel vs Python Data Cleaning Edition video is broken down: 0:00 – Introduction to the data cleaning exercise 7:35 – Data Cleaning using Python – Pandas, Numpy, Jupyter Notebooks 30:05 – Data Cleaning using Excel – PowerQuery 50:50 – Data Cleaning Debate and Scorecards for Excel vs Python