Automate Power Query with Python

[Anonymous]

Is there anyway that can run python scripts to automate apply query step. like changed type, replace value. thank you.

[hackcrr]

Hi, @Anonymous 

The following is a simple example of how to replace values in a column using a Python script:

# Replace values in a column using Python
import pandas as pd

# Input DataFrame
df = pd.DataFrame({
    'Column1': ['A', 'B', 'C', 'D', 'E']
})

# Replace values in Column1
df['Column1'] = df['Column1'].replace({'A': 'X', 'B': 'Y'})

# Return the transformed DataFrame
df

Best Regards,

hackcrr

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