Power BI Desktop和Python； 像花生酱和巧克力

Power BI Desktop helps to visualize complex data with the help of inbuilt and custom visualizations. It allows integrating data from the various data sources and preparing visualization from it.

Power BI Desktop借助内置和自定义的可视化帮助可视化复杂的数据。 它允许集成来自各种数据源的数据并从中准备可视化。

Microsoft recently integrated the Python programming language in the Power BI. Python is a powerful object-oriented language and is used by the data analyst and scientist to analyze complex datasets. We can now use the Python as a preview feature in the Power BI August 2018 release onwards. We can now use Python scripts to generate custom visualization. The combination of these technologies is akin to 1 + 1 = 3 or like the famous ad for Reese’s Peanut butter cups, when chocolate was introduced to Peanut Butter 😉

微软最近在Power BI中集成了Python编程语言。 Python是一种功能强大的面向对象语言，数据分析师和科学家使用它来分析复杂的数据集。 现在，我们可以在Power BI August 2018版本及更高版本中将Python用作预览功能。 现在，我们可以使用Python脚本生成自定义可视化。 这些技术的组合类似于1 +1 = 3或类似当里斯（Reese）的花生酱杯广告中著名的广告，当时在花生酱中引入了巧克力😉

入门 (Getting started)

We should install the Python in the system before we can use the Python scripts in Power BI. Go to the Python Download page and download the installer based on the OS version.

我们应该先在系统中安装Python，然后才能在Power BI中使用Python脚本。 转到“ Python下载”页面，然后根据操作系统版本下载安装程序。

Once the appropriate Python download is completed, click on the installer file to launch it.

适当的Python下载完成后，单击安装程序文件以启动它。

You can choose the highlighted options to install Python for all users. You can enable the option ‘Add Python 3.7 to PATH’ to add this into the environment variable. We will do it manually at a later stage, therefore leave this option unchecked.

您可以选择突出显示的选项来为所有用户安装Python。 您可以启用选项“将Python 3.7添加到PATH”以将其添加到环境变量中。 我们将在以后的阶段手动进行操作，因此请不要选中此选项。

Once the set up is completed, you get the following message ‘Setup was successful’.

设置完成后，您将收到以下消息“设置成功”。

We need to install two Python packages, i.e. Pandas and Matplotlib using the command prompt. Open the command prompt and execute the command. Pandas is an open-source data analysis tool for Python.

我们需要使用命令提示符安装两个Python软件包，即Pandas和Matplotlib。 打开命令提示符并执行命令。 Pandas是用于Python的开源数据分析工具。

Pandas is an open-source, BSD-licensed Python library providing high-performance, and easy-to-use data structures and data analysis tools for the Python programming language

Pandas是经过BSD许可的开源Python库，为Python编程语言提供了高性能且易于使用的数据结构和数据分析工具。

pip install pandas

It downloads the required packages along with its dependencies.

它将下载所需的软件包及其依赖项。

Similarly, we need to install the Matplotlib plotting library for the Python programming language with the below command

同样，我们需要使用以下命令为Python编程语言安装Matplotlib绘图库

pip install matplotlib

In the next step, we need to add the Python folder path in the environment variable. Right click on the computer and view properties. In Properties, go to the advanced system settings, click on the ‘Environment Variables’

下一步，我们需要在环境变量中添加Python文件夹路径。 右键单击计算机，然后查看属性。 在“属性”中，转到高级系统设置，然后单击“环境变量”