Microsoft Introduces Public Preview of Python in Excel
Redmond, WA – In a major development, Microsoft has announced the Public Preview of Python in Excel, allowing users to seamlessly integrate Python and Excel analytics within the same Excel grid.
The integration of Python and Excel is a significant step towards improving data analysis and visualization capabilities for businesses and students alike. Until now, there hasn’t been an easy way to bring together these two popular tools. With Python in Excel, users can manipulate and explore data in Excel using Python plots and libraries, and then further refine insights using Excel’s formulas, charts, and PivotTables.
Microsoft has partnered with Anaconda, a leading enterprise-grade Python repository, to enhance the functionality of Python in Excel. By leveraging Anaconda Distribution for Python running in Azure, this integration includes popular Python libraries such as pandas for data manipulation, statsmodels for advanced statistical modeling, and Matplotlib and seaborn for data visualization.
During the Preview phase, Python in Excel will be available to users with a Microsoft 365 subscription. However, once the Preview is over, certain features will be limited without a paid license.
Python creator Guido van Rossum, now a Microsoft Distinguished Engineer, was instrumental in defining the architecture for Python in Excel. He expressed his excitement about the collaboration, stating, “I’m excited that this excellent, tight integration of Python and Excel is now seeing the light of day. I expect that both communities will find interesting new uses in this collaboration, amplifying each partner’s abilities. When I joined Microsoft three years ago, I would not have dreamed this would be possible. The Excel team excels!”
The introduction of Python in Excel opens up a world of possibilities for users. The powerful combination of Python’s data analysis and visualization libraries with Excel’s familiar features will undoubtedly revolutionize the way data is processed and analyzed.
As Microsoft continues to innovate and collaborate with industry leaders like Anaconda, the future looks promising for Python in Excel. With this integration, users can streamline their workflow and unlock new insights, taking their data analysis capabilities to the next level.