Python in Excel

[amotl]

About

Python in Excel makes it possible to natively combine Python and Excel analytics within the same workbook - with no setup required. With Python in Excel, you can type Python directly into a cell, the Python calculations run in the Microsoft Cloud, and your results are returned to the worksheet, including plots and visualizations.

-- Combining the power of Python and the flexibility of Excel.

Python in Excel brings the power of Python analytics into Excel. Use it to process data in Excel with Python code. You type Python directly into a cell, the Python calculations run in the Microsoft cloud, and your results are returned to the worksheet.

Python in Excel comes with a core set of Python libraries provided by Anaconda. Use Python libraries to simplify your data analysis, find patterns and hidden insights, and visualize your data with plots. To learn more, see Open-source libraries and Python in Excel.

-- Introduction to Python in Excel

A DataFrame is a two-dimensional data structure in computer programming languages, similar to an Excel table. In Python, a DataFrame is an object in the pandas library. The pandas library is a core library used by Python in Excel, and DataFrame objects are a key structure for analyzing data with Python in Excel.

Python in Excel can output a DataFrame in two ways: as a Python object or converted to Excel values. When a DataFrame is returned as a Python object, the cell displays the text “DataFrame”, preceded by a card icon.

-- Python in Excel DataFrames

Synopsis

df = xl("A1:B10", headers=True)
df.groupby("Category").agg("mean")

Details

Python in Excel exposes the best of Python analytics via Anaconda.

Anaconda is a leading enterprise Python repository used by tens of millions of data practitioners worldwide. Python in Excel leverages Anaconda Distribution for Python running in Azure, which includes the most popular Python libraries (e.g. pandas, Matplotlib, scikit-learn, etc.), and is securely built, tested, and supported by Anaconda. Python provided by Anaconda supports a wide array of analytics with Python in Excel.

Python in Excel runs securely on the Microsoft Cloud, with no setup required.

Python code used by Excel runs on the Microsoft Cloud with enterprise-level security as a compliant Microsoft 365 connected experience. The Python code runs in its own hypervisor isolated container using Azure Container Instances and secure, source-built packages from Anaconda through a secure software supply chain.

Status

Announced last year (late summer 2023), rolling out now (early summer 2024).

Note

(6/10/24) UPDATE: Python in Excel is gradually rolling out to Enterprise, Business, Education, and Family and Personal users running Current Channel (Preview) builds on Windows. This feature is rolling out to Excel for Windows, starting with Version 2406 (Build 17726.20016).

[amotl]

Backlog

• Evaluate with pandas' read_sql() method and sqlalchemy-cratedb, if that is even possible to pull into Excel as a 3rd-party package!?
• When possible, and if needed to unlock shipping, level up on packaging matters. Here: Anaconda.
  • Request: Conda package crash#165
  • https://github.com/crate/roadmap/issues/31