Open-source libraries and Python in Excel

Python in Excel is currently in preview and is subject to change based on the feedback. To use this feature, join the?Microsoft 365 Insider Program?and choose the?Beta Channel?Insider level.

Python in Excel is available in Excel for Windows using the Beta Channel. Currently, the feature is not available on other platforms.?

If you encounter any issues with Python in Excel, please report them by selecting?Help?>?Feedback?in Excel.

New to Python in Excel? Start with?Introduction to Python in Excel?and?Getting started with Python in Excel.?

Open-source Python libraries??
        

Python in Excel comes with a standard set of Python libraries provided by?Anaconda?through a secure distribution. Use these Python libraries to simplify your data analysis, find patterns and hidden insights, and visualize your data with plots.?

Core Python in Excel libraries?        

The following open-source libraries are available with Python in Excel by default. They've been imported with the statements listed.?

1. ?matplotlib. Import statement:?import matplotlib.pyplot as plt
2. NumPy. Import statement:?import numpy as np
3. pandas. Import statement:?import pandas as pd
4. seaborn. Import statement:?import seaborn as sns
5. statsmodels. Import statement:?import statsmodels as sm

How to import libraries

        

In addition to the core libraries, you can import additional libraries available through Anaconda. Import Python libraries into Excel using a Python import statement in a Python in Excel cell, such as?import numpy as np. This statement imports the NumPylibrary and assigns it the alias?np. After entering this import statement into a Python cell, you can refer to the NumPy library as?np?throughout the Python formulas in that workbook

#data #microsoft #dataanalytics #datascience #dataengineer