On Tuesday, Microsoft announced the Public Preview of Python in Excel, which "runs securely in the Microsoft Cloud."
Η the company says: “Python is one of the most popular programming languages today, beloved by businesses and students alike, and Excel is an essential tool for organizing, manipulating and analyzing data of all kinds. For these two worlds to work together there was no easy way. Today, we're excited to introduce the Public Preview of Python in Excel for seamless workflow. Python in Excel combines Python's powerful data analysis and visualization libraries with the Excel features you know and love. You can manipulate and explore data in Excel using Python graphics and libraries, and then use Excel formulas, charts, and pivot tables to further enhance your information… in cooperation with Anaconda, a leading enterprise Python repository used by tens of millions of data professionals worldwide.
Python in Excel leverages the Anaconda Distribution for Python running on Azure. It includes the most popular Python libraries such as pandas for data manipulation, statsmodels for advanced statistical modeling, and Matplotlib and seaborn for data visualization….
At preview, Python in Excel will be included in your Microsoft 365 subscription.”
Python creator Guido van Rossum, now a distinguished engineer at Microsoft, helped define the architecture for Python in Excel and said:
“I'm excited that this great, tight integration of Python and Excel is now seeing the light of day. Expect both communities to find interesting new uses in this collaboration, enhancing each partner's capabilities. When I joined Microsoft three years ago, I never dreamed this would be possible. THE team Excel excels!”