Shulou(Shulou.com)11/24 Report--

Hello, everyone. I'm Xiaolan.

There must be a lot of friends who follow Excel already know that something big has happened recently!

What's it about?

You can also use Python in Excel!

Python, a general high-level programming language, is widely used in the fields of software development, data analysis, artificial intelligence and scientific computing. It is famous for its concise syntax and rich library support.

You may not have used it, but basically everyone has heard of it. After all, it was so popular a few years ago! Various courses teaching Python have sprung up like bamboo shoots after a spring rain, official accounts, moments, Douyin. It can be seen everywhere.

This time, the cooperation between Excel and Python, Guido van Rossum, the father of Python, is also involved. Here's what it says about the preview version of Python in Excel:

▲ is translated in Google browser, so how can we experience it? What effects can Python achieve in Excel?

Let's take a look.

1. Enabling PythonPython in Excel in Excel is currently in the testing stage. If you want to use this feature, make sure it is Windows version of Microsoft 365, and join the Microsoft 365 preview experience plan to select the Beta version of the channel.

Click "File" > "account" in the upper left corner of the Excel page.

The following information can be found on the left side of the page:

After the above steps are completed, open the blank workbook:

Click the [Formula] tab, and select [insert Python]-[Python in Excel].

Click [trial Preview] in the pop-up dialog.

Next, we can begin to experience the wonderful use of Python!

2. To start using Python, we just need to enter = PY in the cell or edit bar, select the data, press [Ctrl+Enter] to submit the code, and we can call Python!

Using Python, we can achieve visualization, data cleaning, machine learning, predictive analysis and other functions.

▋ Visualization can quickly produce charts with a simple one-line formula.

If you use famous Python chart libraries such as Matplotlib and seaborn, you can easily create a variety of advanced charts.

▋ machine learning, prediction analysis and prediction use the functions of Python libraries such as scikit-learn and statsmodels to realize machine learning, prediction analysis and prediction techniques, such as predicting the future weather.

▋ data cleaning uses advanced data cleaning techniques to easily accomplish tasks such as extracting dates from text.

The ▋ team uses "Python in Excel is built for the team." "

Users can share workbooks and collaborate seamlessly through comments, @, and co-authoring with colleagues.

In addition, when using Python, you don't have to worry about being unable to calculate because the amount of data is too large, because it is calculated on the cloud.

3. In the end, this article gives a general introduction to how to experience Python in Excel and what it can do.

If you want to try, then hurry up, because the current preview version is free, but you may have to charge for it after the official release!

Reference link:

[1] https://techcommunity.microsoft.com/t5/Excel-blog/announcing-python-in-Excel-combining-the-power-of-python-and-the/ba-p/3893439

[2] https://support.microsoft.com/zh-cn/Office/Excel-%E4%B8%AD%E7%9A%84-python-%E7%AE%80%E4%BB%8B-55643c2e-ff56-4168-b1ce-9428c8308545

[3] https://www.microsoft.com/en-us/microsoft-365/python-in-Excel

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Zhu Lan

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.