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
2 years ago

Hi there, im facing the same issue when i wanna make my automation data cleaning and after attempting so many code i think this one is gonna work on you too... here's the code 

column_name = 'YourColumnName'
replacement_value = 'NewValue'
dataset[column_name].replace({'OldValue': replacement_value}, inplace=True)