Do NOT Use Python in Excel for Data Wrangling! Here's Why.

In 2024, using Python in Excel for data wrangling isn't a great idea. Surprised? All will be clear when you consider how Python in Excel works behind the scenes.

Data wrangling is one of the most important tasks in analytics.

Estimates are 60-80% of the time required for analytics projects (especially advanced analytics projects) is spent on acquiring, filtering, cleaning, combining, enriching, and transforming data.

As a hands-on analytics professional, I can tell you this is no exaggeration!

Trust me. You want to use the best technology for your data wrangling.


☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData


--------------------------------------------------------------------------------------------
VIDEO CHAPTERS
--------------------------------------------------------------------------------------------
00:00 Intro
01:04 Python in Excel Architecture
02:49 Data Wrangling Options
05:52 Python in Excel Wrangling Exceptions
07:36 Python in Excel’s Future


--------------------------------------------------------------------------------------------
FREE MACHINE LEARNING CRASH COURSES
--------------------------------------------------------------------------------------------
If you're ready to see what Python in Excel skills make possible, be sure to check out my FREE on-demand machine learning crash courses!

Here's what you get with any of these courses:
1️⃣ On-Demand: Watch the course when it fits your schedule
2️⃣ PDF of all slides
3️⃣ All Python code as a Jupyter Notebook
4️⃣ All data so you can experiment
5️⃣ Resources to continue your learning.

Machine learning with Python in Excel. You've got this if you want it:
💻 Decision Trees with Python:
https://bit.ly/DecisionTreesWithPython

💻 Tuning Decision Trees with Python:
https://bit.ly/TuningDecisionTreesWit...

💻 Logistic Regression with Python:
https://bit.ly/LogisticRegressionWith...

💻 Cluster Analysis with Python:
https://bit.ly/ClusterAnalysisWithPython

#pythoninexcel #pythonexcel #pythonforexcel