Microsoft is introducing Python to Excel, allowing users to manipulate and analyze data from Python within the Excel environment. This feature will be available as part of Excel’s built-in connectors and Power Query, without the need for additional software or add-ons. Through a partnership with Anaconda, Python libraries like pandas, statsmodels, and Matplotlib will be accessible in Excel. Users will be able to create formulas, PivotTables, and charts based on Python data, and visualize their findings with libraries like Matplotlib and Seaborn. Guido van Rossum, the creator of Python, expressed excitement about the collaboration. The Python in Excel feature is now available as a public preview for Microsoft 365 Insiders in the Beta Channel.
https://www.theverge.com/2023/8/22/23841167/microsoft-excel-python-integration-support