-------------------------------------------------------------------------------------------- MY FREE PYTHON CRASH COURSE ON RUclips -------------------------------------------------------------------------------------------- 📺 Part 1 - Introduction ruclips.net/video/gtnwA24-N5s/видео.html 📺 Installing Anaconda Python on Windows ruclips.net/video/BFTEA9Jt7hI/видео.html 📺 Installing Anaconda Python on Mac ruclips.net/video/AX40aqRVlAw/видео.html 📺 Part 2 - What is Python? ruclips.net/video/R5HV1XWBV3g/видео.html 📺 Part 3 - Using Jupyter Notebooks ruclips.net/video/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
Took your crash courses and they are fab. Your explanations are much easier to understand than most of what I've encountered in my self-teaching journey.
@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!
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.
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.
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)
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.
--------------------------------------------------------------------------------------------
MY FREE PYTHON CRASH COURSE ON RUclips
--------------------------------------------------------------------------------------------
📺 Part 1 - Introduction
ruclips.net/video/gtnwA24-N5s/видео.html
📺 Installing Anaconda Python on Windows
ruclips.net/video/BFTEA9Jt7hI/видео.html
📺 Installing Anaconda Python on Mac
ruclips.net/video/AX40aqRVlAw/видео.html
📺 Part 2 - What is Python?
ruclips.net/video/R5HV1XWBV3g/видео.html
📺 Part 3 - Using Jupyter Notebooks
ruclips.net/video/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
Took your crash courses and they are fab. Your explanations are much easier to understand than most of what I've encountered in my self-teaching journey.
Wow! Thank you so much for this. I take it as quite the compliment.
utterly superb.
you got a course on altruism too? Wow.
I'm going to take this at face value and say thank you for the kind words.
Do you prefer Plotnine over Seaborn now?
@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!
Major problem I see is that it isn't run locally.
Interestingly enough, most of my clients actually see this as a huge advantage. For example, no need to involve IT.
@@DaveOnData, for anyone in Healthcare it is an issue. Can't ensure HIPAA compliance.
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.
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.
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)
Are there any capabilities to extract pdf data into excel using python? I’ve found the power query import incredibly limiting
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.
@@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.