dataframe not generated automatically by fields I select

[OfirKe]

Hi,

Using the python script editor, when I drag fields to the Values field, the script is not updating and staying as it is:

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

# = pandas.DataFrame()

# = .drop_duplicates()

# Paste or type your script code here:

I'm expecting the script to update automatically to:

# dataset= pandas.DataFrame(age,type_part) 

# dataset= dataset.drop_duplicates()

any idea how to fix it?

[OfirKe]

Hi,

The version is 2.96.701.0 64-bit

the python IDE is pycharm.

Here's what's happening when adding values (python script not generating the dataframe automaticaly)

[v-kkf-msft]

Hi @OfirKe ,

Please install required Python packages, see if it works.

pip install pandas

pip install matplotlib

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

[OfirKe]

Hi, the packages already installed and I managed to do visualizations, but the problem still not solved as the data-frame not generating automatically as mentioned above.

[v-kkf-msft]

Hi @OfirKe ,

Please download and install the latest version 2.96.1061.0 , and see if it works.

Best Regards,
Winniz

[v-kkf-msft]

Hi @OfirKe ,

When I add a Python visual in Power BI Desktop and drag fields to the Values, the script can update. Which version of Desktop are you using? Do you have Python locally installed and the correct Python installation path specified in the Desktop option?

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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