Forum Discussion

Jeanxyz's avatar
Jeanxyz
Power Participant
2 years ago
Solved

get data via python script

I'm learning to import data via python script following Microsoft tutorial (https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts). I have installed python, pandas, matplotli...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    works fine for me.  Re-do your Python setup on that PC.

    No need to print the variable.

     

     

    let
    Source = Python.Execute("import pandas as pd#(lf)data = [['Alex',10],['Bob',12],['Clarke',13]]#(lf)df = pd.DataFrame(data,columns=['Name','Age'])"),
    df1 = Source{[Name="df"]}[Value]
in
    df1

     

     

     

lbendlin's avatar
lbendlin
Super User
2 years ago

works fine for me.  Re-do your Python setup on that PC.

No need to print the variable.

 

 

let
    Source = Python.Execute("import pandas as pd#(lf)data = [['Alex',10],['Bob',12],['Clarke',13]]#(lf)df = pd.DataFrame(data,columns=['Name','Age'])"),
    df1 = Source{[Name="df"]}[Value]
in
    df1