Amazing, Owen. I'm speechless 🙂 Since you are using the same data over several "lessons", would it be possible to upload the original Tour de France file?
You'll definitely need to sign up for the Office Insiders Beta Channel. After that, I still think the rollout is gradual at this point but will become more widespread in the coming weeks. Start here: support.microsoft.com/en-us/office/getting-started-with-python-in-excel-a33fbcbe-065b-41d3-82cf-23d05397f53d
Did you have any issues actually getting Python to run? I've joined the Beta program, reinstalled, ran as admin, but nothing seems to be working. Do I need to have something else from MS installed?
I think you've done everything that's needed - I just think the rollout to Insiders Beta is being done gradually and may be a little time until everyone on the channel gets hold of it. However, I could be wrong about this, so you might want to raise a feedback thread via help.
I selected the "Team" column, did a Ctrl + H with the "Find what" field empty and the "Replace with" field containing a single quote and, after that, the statement "df['Team']=df['Team'].replace('','No team')" worked.
I receive connection errors when I am trying to connect to localhost with Flowise or Local LLM APIs. In Python it's ok, but with excel it's not. Any thoughts?
Python in Excel is not connected to the Internet and cannot access local or network files. It's limited to the data you give it via the Excel spreadaheet or Power Query. So your best bet is to connect to your data source with Power Query and then feed the query into the xl method in the Python cell
@@flexyourdata It would be great to do a video like this one. An example? Basically, I want to work with LLM calls like they are functions. I did this with a macro (chatgpt) wrote the code. Works well, but the excel freezes. This is why I want to use PYthon. However I don't know how to make it work this way. So flexibly I can use like a normal Excel function.
I'm not sure I follow. You can definitely perform calculations with Python in Excel. But you can't edit a cell that is already populated with data from another source. For example, if you type a number in a cell, you can't use the Python in Excel runtime to alter what's in that cell unless you convert that cell in to a Python cell first. But, you can grab the number from that cell, perform some calculation on it, and return it to the cell where the Python code is. Hope this makes sense.
Say, what I need to do in Excel to get this statsmodels to work? import pandas as pd import numpy as np import matplotlib.pyplot as plt import seaborn as sns from statsmodels.tsa.stattools import adfuller from statsmodels.graphics.tsaplots import plot_acf, plot_pacf
“Think of it as a 2-dimensional Jupyter notebook”. Love that.
It really is! The more I play with it, the more it holds true. The grid is front and center to the experience. Always has been. :)
@@flexyourdata the grid is intuitive, and user-friendly, imo.
Thank you. Beginner here. I will watch all your videos..
Welcome! Let me know if anything's not clear.
Thanks for the introduction, Owen. Cool as always!
Excel could be a great canvas for working with dataframes
I'm excited for the upcoming videos!
Just subscribed to the channel. Thanks for posting this very interesting playlist about Python in Excel.👍
Wow, didn't even know you could run Python in Excel. Lots of possibilities to extend functionality beyond coding in VBA & PowerQuery...
It's in beta channel at the moment but I suppose will be iterated then released to GA later.
Amazing, Owen.
I'm speechless 🙂
Since you are using the same data over several "lessons", would it be possible to upload the original Tour de France file?
Hi Meni, no problem. I downloaded that dataset from Maven Analytics. Here: mavenanalytics.io/challenges/maven-tour-de-france-challenge/25
@@flexyourdata
I'm owing you, Owen 😜😜😜
Hello. Thanks for your great video 👍 Is it necessary to buy official o365 and then join in beta program?!
Yes you need an O365 subscription and you must join Office Insiders on the Beta Channel.
Thanks for the video, Please how can you get the new python option?? is there any link to updates??
You'll definitely need to sign up for the Office Insiders Beta Channel. After that, I still think the rollout is gradual at this point but will become more widespread in the coming weeks.
Start here:
support.microsoft.com/en-us/office/getting-started-with-python-in-excel-a33fbcbe-065b-41d3-82cf-23d05397f53d
Thank you for helping!@@flexyourdata
Gracias!!! Brilliant!!!!
Did you have any issues actually getting Python to run? I've joined the Beta program, reinstalled, ran as admin, but nothing seems to be working. Do I need to have something else from MS installed?
I think you've done everything that's needed - I just think the rollout to Insiders Beta is being done gradually and may be a little time until everyone on the channel gets hold of it. However, I could be wrong about this, so you might want to raise a feedback thread via help.
I cannot see the PYTHON tab in the EXCEL FORMULA Ribbon? How to get it? I have office 365
For now, you have to join Office Insiders and enable the Beta Channel.
How Do I Join?@@flexyourdata
The statement df['Team']=df['Team'].replace('','No team') does not work for me. It produces a "None" instead of 'No team'
I selected the "Team" column, did a Ctrl + H with the "Find what" field empty and the "Replace with" field containing a single quote and, after that, the statement "df['Team']=df['Team'].replace('','No team')" worked.
mate, amazing video!
df.columns (dot columns) quite handy, mate. thanks! (re-watching the video)
How to install the Python libraries which are missing in the Python for Excel?
I receive connection errors when I am trying to connect to localhost with Flowise or Local LLM APIs. In Python it's ok, but with excel it's not. Any thoughts?
Python in Excel is not connected to the Internet and cannot access local or network files. It's limited to the data you give it via the Excel spreadaheet or Power Query. So your best bet is to connect to your data source with Power Query and then feed the query into the xl method in the Python cell
@@flexyourdata It would be great to do a video like this one. An example?
Basically, I want to work with LLM calls like they are functions. I did this with a macro (chatgpt) wrote the code. Works well, but the excel freezes. This is why I want to use PYthon. However I don't know how to make it work this way. So flexibly I can use like a normal Excel function.
❤❤❤
Does this add anything to what we can do already in Excel?
Plenty. For example - built in machine learning algorithms in scikit-learn. Regular expressions via regex.
The best
how I can get the dataset
can we have data set for practice
There are lots of free datasets out there. The one from the video is from here:
mavenanalytics.io/challenges/maven-tour-de-france-challenge/25
Is it possible to manipulate cell values with python?
I'm not sure I follow. You can definitely perform calculations with Python in Excel. But you can't edit a cell that is already populated with data from another source. For example, if you type a number in a cell, you can't use the Python in Excel runtime to alter what's in that cell unless you convert that cell in to a Python cell first. But, you can grab the number from that cell, perform some calculation on it, and return it to the cell where the Python code is. Hope this makes sense.
How to install it; i use office 2016
You will need O365 Insiders Beta Channel for this feature. It won't work on Office 2016, unfortunately.
Say, what I need to do in Excel to get this statsmodels to work?
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns
from statsmodels.tsa.stattools import adfuller
from statsmodels.graphics.tsaplots import plot_acf, plot_pacf
What's not working?
@@flexyourdata thanks, for you reply. I was able to get it to work by adding, import statsmodles the the code in Excel.