Do NOT Use Python in Excel for Data Wrangling! Here's Why.
Vložit
- čas přidán 23. 07. 2024
- 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: 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:
bit.ly/DecisionTreesWithPython
💻 Tuning Decision Trees with Python:
bit.ly/TuningDecisionTreesWit...
💻 Logistic Regression with Python:
bit.ly/LogisticRegressionWith...
💻 Cluster Analysis with Python:
bit.ly/ClusterAnalysisWithPython
#pythoninexcel #pythonexcel #pythonforexcel - Věda a technologie
Can't get access to Python in Excel from Microsoft? No worries! Check out my video on how you can get started NOW: czcams.com/video/0iV4FtpSriY/video.html
Another awesome video. I'll continue to say I really like that you talk about somewhat complex subjects in simple and everybody terms.
Thank you for the compliment and the ongoing support of the channel! A good chunk of my work is teaching professionals from diverse backgrounds in advanced analytics (e.g., machine learning). As such, your words are very much appreciated.
Added response.... it is pronounced by the smart people as:
S
Q
L
;)
I would say we need to agree to disagree on that point! 🤣
Helpful insights. Much appreciated
Glad you found the content useful!
I wish we could have option to choose to use local system python env.
That might be an option down the road. I have clients excited by the idea of no local install.
@@DaveOnData I was excited too! But I think I will have to wait futher.
I agree. It is nice having the power of someone else's system. Butt would with patient data, I get nervous if I'm not completely in control.
@@michaelt312 - There are many industries where this is the case. Microsoft, along with the other cloud providers, of course are working to get folks comfortable with the cloud - but your mileage may vary. You might find the following Azure article about HIPPA of interest:
learn.microsoft.com/en-us/azure/compliance/offerings/offering-hipaa-us
@@DaveOnData, I am sure they are safe, but.... I've seen too many instances of data dumps. I am doing stuff with non-PHI. Which will bring me to a question. I'll post that later.
When the pandas course come?
I want to get to this soon, but as I work on the content plan it just keeps getting bigger and bigger. It's likely to be an hour-long video. Maybe more.