Hello,
I would like to use Anaconda Toolbox for excel.
However I don’t know the environment.
How to start ? What’re the main packages for data sciences ?
Thanks for your help.
1 Like
Hi Chris
Anaconda Toolbox for Excel enables two ways to work with Python in the Excel application:
- by providing tools that work with “Python in Excel”, which is the official Microsoft integration. To see the packages available in Python in Excel, create a Python cell in Excel by typing =PY( in a cell. Then, in the Python cell, use this code to see the packages:
pip list
The list of packages will appear in the Python Editor output.
- by using Anaconda Code. This is accessible via the Code button on the Anaconda Toolbox button group on the formulas tab of the ribbon. The list of packages installed by default is visible on the Environment tab of the add-in. You can then search for other packages from the same tab (Environment) by clicking the “Add” button and searching.
For a comprehensive introduction to Anaconda Code, try this video:
1 Like
Hello,
Thank you for your answers.
=> For free users, are there any limits to calculations ?
For instance, this message is written in french :
“ PYTHON DANS EXCEL vous utilisez une vitesse de calcul standard de Python dans Excel “ (see the yellow color)
Hi Chris
Yes, there are limits for free users of Python in Excel. The limits are only in terms of what is described as “Standard Compute” (which is free) and “Premium Compute” (which requires the Python in Excel Add-On license). The experienced difference will be that the free version will encounter slower execution speeds. The details are described here:
1 Like
Hello Owen,
Thank you again.
Best regards