I am trying to replace 100 in one of my columns with 0.
I have tried replace() function and it is not giving me the expected results.
val df2 = df1.replace("col", 100, 0)
I want all rows with 100 in column col to be replaced by 0. Thanks for your help.