Get the App
SLTechnology News&Howtos  ›  IT Information  › 

Microsoft Excel announces integration of Python: users can call the Anaconda distribution to perform various operations through the new "= PY" function

Shulou Source: shulou.com Published: 2023-11-24 18:56:42 11月17日 Update

Thanks to CTOnews.com netizens and soft media users for 1520111 clue delivery! CTOnews.com August 22, Microsoft has natively integrated Python into the public beta version of Excel, which was first launched to Microsoft 365 Insiders, enabling users to make better use of Excel with the help of Python libraries, data visualization and analysis capabilities.

Currently, this feature can only be used in the desktop version of Excel, but Microsoft says Python computing can also be run in the Microsoft cloud. If you are interested, you can now join the Microsoft 365 Insider program and select the Beta channel to get the latest Excel version.

With Python natively integrated into the Excel grid, users can enter Python code directly into the Excel cell through the new "= PY" function. Excel users can seamlessly use Python in formulas, charts, and PivotTables.

It is reported that Python libraries (such as pandas, matplotlib and scikit-learn) provide a variety of analytical capabilities, including data visualization, data cleaning, machine learning and predictive analysis. By integrating Python functions, these features are more easily available to users.

CTOnews.com notes that Excel's integrated Python comes from the Anaconda distribution, a widely used Python repository where you can find a variety of popular Python libraries and tools supported by Anaconda.

Peter Wang, CEO and co-founder of Anaconda, said:

I am pleased to announce the integration of Anaconda distribution Python into Microsoft Excel-a major breakthrough that will change the workflows of millions of Excel users around the world.

In addition, users can share working files containing Python code with team members through tools such as Microsoft Teams and Outlook.

Tags: Users Microsoft features tools data analysis distribution code can pass capabilities this is visualization work functions significant happy repositories global formulas interests Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Xiaomi Microsoft macOS Redmi vpn