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

Подписаться 74 тыс.

Просмотров 1,5 тыс.

50% 1

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

Наука

Опубликовано:

19 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 20

@DaveOnData 2 месяца назад

Can't get access to Python in Excel from Microsoft? No worries! Check out my video on how you can get started NOW: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0iV4FtpSriY.html

@michaelt312 2 месяца назад

Another awesome video. I'll continue to say I really like that you talk about somewhat complex subjects in simple and everybody terms.

@DaveOnData 2 месяца назад

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.

@michaelt312 2 месяца назад

Added response.... it is pronounced by the smart people as: S Q L ;)

@DaveOnData 2 месяца назад

I would say we need to agree to disagree on that point! 🤣

@nishantkumar9570 2 месяца назад

I wish we could have option to choose to use local system python env.

@DaveOnData 2 месяца назад

That might be an option down the road. I have clients excited by the idea of no local install.

@nishantkumar9570 2 месяца назад

@@DaveOnData I was excited too! But I think I will have to wait futher.

@michaelt312 2 месяца назад

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.

@DaveOnData 2 месяца назад

@@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

@michaelt312 2 месяца назад

@@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.

@mcwahaab Месяц назад

Helpful insights. Much appreciated

@DaveOnData Месяц назад

Glad you found the content useful!

@rolandocooper2477 2 месяца назад

When the pandas course come?

@DaveOnData 2 месяца назад

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.