The popular programming language Python will now be
accessible in Excel. Available directly in the Excel ribbon, Python can be used
to conduct advanced data analysis, including manipulating and exploring data. The
insights can be further refined using Excel’s own formulas, charts and
PivotTables.
Python will be available in Excel as part of the software’s
built-in connectors and Power Query, which means that users won’t need to
separately download a software or set up an add-on to access it. Popular Python
libraries like pandas, statsmodels, and Matplotlib will also be accessible in
Excel.
Additionally, users will be able to view their Python data within the grid of their Excel spreadsheet, as a result of a new PY function. All Python calculations will take place in the Microsoft Cloud and the results will return to the Excel spreadsheets.
Python data in Excel
The Python integration in Excel is currently only available
as a preview and is included in the Microsoft 365 subscription. Microsoft says
that the functionality will be first launched to Windows and later to other
platforms as well.
