Within the Python in Excel environment, you can directly create and interact with dataframes (the fundamental data structure in Python's powerful pandas library).

Microsoft is bringing popular programming language Python to Excel. A public preview of the feature is available today, allowing Excel users to manipulate and analyze data from Python.

Excel gets containerized, cloud-based Python analytics and visualization powers Visualization and analytics tools available in preview, but may be paywalled.

While Excel offers many formatting options to make your workbook visually appealing, manually formatting large datasets can be incredibly tedious. But Python can automate it with ease.

This will enable users to perform complex statistical analysis, advanced visualizations, predictive analytics, and machine learning in Excel.