Connection through python script

[vasimnps]

Following instructions from here https://docs.microsoft.com/en-us/power-bi/desktop-python-scripts

I can run the following python code and generate data.

import pandas as pd data = [['Alex',10],['Bob',12],['Clarke',13]]
df = pd.DataFrame(data,columns=['Name','Age'],dtype=float)
print (df)

I contructed same df in a class - created a package named Mypackage

import pandas as pd
class Mydata:
    def __init__(self):
    pass

    def main_page(self):
    data = [['Alex',10],['Bob',12],['Clarke',13]]
    df = pd.DataFrame(data,columns=['Name','Age'],dtype=float)
    return df

Now when I call the data, nothing is returned

from Mypackage import MyData
df = Mydata().main_page()
print(df)

If I try 

from Mypackage import MyData
df = Mydata().main_page()
print(df.head())

 Then I get the following error

Unable to connect
Details: "ADO.NET: Python script error.
Traceback (most recent call last):
  File "PythonScriptWrapper.PY", line 13, in <module>
    print(df.head())
AttributeError: 'NoneType' object has no attribute 'head'
"

[v-xuding-msft · Accepted solution]

Hi @vasimnps ,

What the version of Python do you install? If you use 3.7, please install Python 3.6 to have a try. And make sure you have installed Pandas package.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vasimnps]

Thank you very much @v-xuding-msft 

V3.6 did the trick, any reason why so?