Anaconda Inc.leading provider of data science, machine learning, and artificial intelligence solutions, today announced the general availability of Python in Excel. This integration with Microsoft Excel allows users to safely run Python code directly in the Excel grid without requiring a separate Python installation.
Since its release Public View in August 2023, Python in Excel has been met with widespread applause from both the data science and business analyst communities. Microsoft Insiders have begun using Python in Excel to perform intricate analysis without leaving their familiar Excel environment. Now publicly available, Python in Excel is set to change the way millions of Excel users and Python practitioners approach their work.
Excel users can now take advantage of Python’s advanced data manipulation, statistical analysis, and data visualization capabilities without leaving the familiar spreadsheet environment.
This opens up novel possibilities for intricate analysis and advanced visualizations. Python practitioners can also seamlessly connect their scripts and wealthy visualizations with the widespread availability of Excel. This integration provides an uninterrupted workflow and simplifies sharing your work with colleagues who primarily utilize Excel.
Key Features and Benefits
- Plain integration:Using Python in Excel is as straightforward as typing “=PY(” followed by the Python code in an Excel cell. The results of Python calculations or visualizations appear directly in the Excel spreadsheet.
- Advanced data visualizations:Create intricate data representations in Excel using tough Python libraries such as Matplotlib and Seaborn.
- Deep statistical analysis:Perform intricate statistical tasks directly in Excel cells using advanced Python libraries such as pandas and statsmodels.
- Trouble-free cooperation:Share Python-enhanced Excel files and collaborate with colleagues while preserving the complexity and analysis power of Python in an Excel-friendly format.
- Access to wealthy Python libraries:Leverage the extensive ecosystem of Python libraries for data manipulation, statistical modeling, and data visualization—all available in Excel.
The Anaconda Distribution for Python integration with Excel is not just a feature—it redefines what’s possible in data science. By combining the advanced capabilities of Python with the ubiquitous Excel platform, this integration bridges the gap between advanced data science and everyday business tools.
Empowering all users
Excel users will now have access to:
- Data preparation:Neat and prepare your data with Python to save time and effort while you focus on the actual analysis.
- Custom logic and calculations:Apply Python expressions for custom calculations to meet both elementary and intricate needs.
- Advanced statistical modeling:Apply Python’s extensive statistical and mathematical libraries to perform analysis that goes beyond the built-in capabilities of Excel.
- Machine learning models:Build, train, and evaluate machine learning models in Excel using popular Python libraries like Scikit-learn.
- Predictive analytics:Apply machine learning models to predict future trends based on historical data directly in Excel.
Experience the power of Python in Excel for yourself by signing up for this training with Microsoft Excel MVP and Python expert David Langer.
Anaconda is committed to equipping Python in Excel users with all the tools they need to succeed. In addition to its extensive library of educational resources, the recently released Anaconda Toolkit for Excel allows users to easily generate code, create visualizations, collaborate with other Python users, and much more.
Python in Excel is now available for Excel users on Windows. For more information on getting started with Python in Excel, visit Microsoft’s support page HERE.