Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Power BI - How to use Python script to do a search and replace

Hi,  I would like to use a Python script to do an automatic Search and Replace just like we can do with Excel. In the following example, I would like to replace all the X by Y, I used the following...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous  and thank you for your reply!

    I tried to use your script but unfortunately, it's not working for me. I have the same behavior as with the script I used previously.

    And thanks for the Power Query process.

    My goal with using python is to automate my data cleaning. This is for a report that I run every week and I am basically renaming a bunch of projects. I'd like to automate this part and just run a script to save some time.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Anonymous ,

      Please update the script as below:

      # 'dataset' holds the input data for this script
import pandas as pd
dataset['Text'] =pd.DataFrame(dataset['Text'].str.replace('X', 'Y', regex=False))

      The original data in my table as shown in below screenshot:

      After applied the above script can become the below result:

      Best Regards