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 6080% of the time required for analytics projects (especially advanced analytics projects) is spent on acquiring, filtering, cleaning, combining, enriching, and transforming data.
As a handson 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 ondemand machine learning crash courses!
Here's what you get with any of these courses:
1⃣ OnDemand: 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