Can You Do Data Science With Python in Excel in 2024?
Vložit
- čas přidán 23. 07. 2024
- 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.
☕ 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: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:
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
🚨 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! 🎉
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.
I 100% agree! I know that many are skeptical of Python in Excel (e.g., it's designed to run in the cloud), but my view mirrors yours - this is only the start of something big.
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!
Thank you for the feedback! I am happy to hear you are finding my content useful.
YES!!! minute 2:05 = Thank you David!
David, it would be interesting to see the demos of those scenario. A peak in 🔍👀😁!
Glad to hear that my rant didn't offend you!
Analyzing telemetry data would make for an interesting video. I will have to think about that. 🤔
I feel like "Real Data Science" should always be set off with sarcastic air quotes... 😂
A fair point! "Real data science" is certainly subjective.
Good job! Thank you for sharing.
Thank you for the kind words! I am glad you liked the video.
Do you have experience in using openPYxl? If so, what has been your experience in using it?
Unfortunately, I do not have any experience with other Python technologies that directly integrate with Excel.