Can You Do Data Science With Python in Excel in 2024?

preview_player
Показать описание
Data science is the top use case for Python in Excel! However, a fundamental question remains - can you do real data science with Python in Excel?

I have tested Python in Excel's scalability with various real-world data science scenarios and report my findings in this video.

--------------------------------------------------------------------------------------------
VIDEO CHAPTERS
--------------------------------------------------------------------------------------------
00:00 Intro
01:36 Datasets
04:46 Visual Data Analysis
07:48 Cluster Analysis
11:11 Decision Tree ML Models
14:40 Random Forest ML Models
17:21 The Verdict

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

💻 Tuning Decision Trees with Python:

💻 Logistic Regression with Python:

💻 Cluster Analysis with Python:

#pythoninexcel #pythonexcel #pythonforexcel
Рекомендации по теме
Комментарии
Автор

🚨 BREAKING NEWS - The Python in Excel timeout can be adjusted! Here's how you set it in Excel:

File > Options > Advanced > When calculating this workbook

I set the timeout to 600 seconds (i.e., 10 minutes), and all test cases now pass! 🎉

DaveOnData
Автор

Another great video. In my not so humble view.... Python in Excel isn't about where it is, but where it is going.
On my end, I'm working on sterile data that doesn't have PHI. Getting sign off from the three main hospitals I work with. I think a lot of insight can be gained after watching your series.

michaelt
Автор

I appreciate the evaluation and honesty. Even if Excel ends up being the conduit to doing full blown analysis in Python, it is worthy venture. I am 12 videos in to your Python refresher and am enjoying the content. Can't wait to get the ML content. Keep up the good work!

kristoferbrown
Автор

I feel like "Real Data Science" should always be set off with sarcastic air quotes... 😂

Major_Data
Автор

Do you have experience in using openPYxl? If so, what has been your experience in using it?

nayeem