Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Pandas is not recognized.

When running the script the visual displays "Can't display this visual. See details"

I click it and it says:

Python script error.

<pi> File "PythonScriptWrapper.PY", line 18

  dataset = pd.DataFrame(DT , DT Code)


SyntaxError: invalid syntax



I have the following code. 


1 # The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your  script:

2 import pandas as pd

3 dataset = pd.DataFrame(DT , DT Code)

4 # dataset = dataset.drop_duplicates()

5 import matplotlib.pyplot as plt

6 dataset.plot(kind='bar',x='DT)',y='DT')



Lines 1,3,4 are auto generated when I click and drag my data into the python visual. I impetrated pandas to try and fix the issue i have

I plot DT vs DT since I know they are the same length and that way I know there is not a plotting error. 


I have pandas, numpy, and matplot lib installed and have even referenced my script to a new env instead of my root python to try to get it to work. I am using python 3.8. 

Community Support
Community Support

Hi @jbengineer 


Which version of the Pandas package are you using?


Community Support Team _ Jing

Hey @v-jingzhang ,


I am using pandas version 1.0.5

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors