Excel Users: What You NEED to Learn for Python in Excel!

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

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

50% 1

Don't waste time! This video shows you what you need to learn to get the most out of Python in Excel to become a data rockstar at work.
Make no mistake. In 2024, there will be two kinds of Excel users.
Those with Python in Excel skills and those without. You DO NOT want to be in the second group.
If you're ready to differentiate yourself at work with powerful analytics and data science skills, this video will provide you with a Python in Excel roadmap.
☕ 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
00:40 You Need to Learn Basic Python
01:38 You Need to Learn pandas and seaborn
04:21 You Need to Learn statsmodels
06:28 You Need to Learn scikit-learn
08:42 The Two Kinds of Excel Users
--------------------------------------------------------------------------------------------
MY FREE PYTHON CRASH COURSE ON RU-vid
--------------------------------------------------------------------------------------------
📺 Part 1 - Introduction
• Python Crash Course: P...
📺 Installing Anaconda Python on Windows
• Python Crash Course: I...
📺 Installing Anaconda Python on Mac
• Python Crash Course: I...
📺 Part 2 - What is Python?
• Python Crash Course: P...
📺 Part 3 - Using Jupyter Notebooks
• Python Crash Course: P...
--------------------------------------------------------------------------------------------
FREE DATA SCIENCE CRASH COURSES
--------------------------------------------------------------------------------------------
If you're ready to see what Python skills make possible, be sure to check out my FREE on-demand data science 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.
Data science with Python. 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 #python

Наука

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

15 июн 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

-------------------------------------------------------------------------------------------- MY FREE PYTHON CRASH COURSE ON RU-vid -------------------------------------------------------------------------------------------- 📺 Part 1 - Introduction ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gtnwA24-N5s.html 📺 Installing Anaconda Python on Windows ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BFTEA9Jt7hI.html 📺 Installing Anaconda Python on Mac ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-AX40aqRVlAw.html 📺 Part 2 - What is Python? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-R5HV1XWBV3g.html 📺 Part 3 - Using Jupyter Notebooks ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5wibG8wOXB8.html -------------------------------------------------------------------------------------------- FREE DATA SCIENCE CRASH COURSES -------------------------------------------------------------------------------------------- If you're ready to see what Python skills make possible, be sure to check out my FREE on-demand data science 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. Data science with Python. You've got this if you want it: 💻 Decision Trees with Python: bit.ly/DecisionTreesWithPython 💻 Tuning Decision Trees with Python: bit.ly/TuningDecisionTreesWithPython 💻 Logistic Regression with Python: bit.ly/LogisticRegressionWithPython 💻 Cluster Analysis with Python: bit.ly/ClusterAnalysisWithPython

@GabrielleAmadeusMozart 17 дней назад

utterly superb. you got a course on altruism too? Wow.

@DaveOnData 17 дней назад

I'm going to take this at face value and say thank you for the kind words.

@MichaelSumner-cs7gc 3 дня назад

Do you prefer Plotnine over Seaborn now?

@DaveOnData 3 дня назад

@MichaelSumner-cs7gc - I was an R user and a huge fan of ggplot2 for many years. Not surprisingly, I've always preferred plotnine and have asked Microsoft to include it in Python in Excel. I use seaborn right with Python in Excel because it is better matplotlib. Hopefully Microsoft will get plotnine added soon!

@VastCNC 4 месяца назад

Are there any capabilities to extract pdf data into excel using python? I’ve found the power query import incredibly limiting

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

The short answer is no. The longer answer is Microsoft has locked down Python in Excel for security reasons. One aspect of this is that Python in Excel can't access the file system of your computer.

@VastCNC 4 месяца назад

@@DaveOnData office scripts is the same way, partly for security, but the cynical part of me thinks it’s also partly for power automate adoption.

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

Major problem I see is that it isn't run locally.

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

Interestingly enough, most of my clients actually see this as a huge advantage. For example, no need to involve IT.

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

@@DaveOnData, for anyone in Healthcare it is an issue. Can't ensure HIPAA compliance.

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

Interesting. Azure has specialized offerings for various verticals (e.g., the US federal govt). I can't imagine their not working to get Python in Excel approved for these verticals.

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

Also, the Azure container in which Python in Excel runs is far more secure than any local Python installation. As a recovering Enterprise Architect, I would much rather folks use Python in Excel instead of the alternatives that integrate with Excel locally.

@andrewferguson6901 4 месяца назад

Think enterprise and it makes a lot of sense. Lots of sheets are networked shared resources in a datacenter/cloud so it makes sense to run code in that same environment (with *ahem* security precautions)