Python Pandas replace multiple columns zero to Nan
I think you need replace by dict:
cols = ["Weight","Height","BootSize","SuitSize","Type"]df2[cols] = df2[cols].replace({'0':np.nan, 0:np.nan})
You could use the 'replace' method and pass the values that you want to replace in a list as the first parameter along with the desired one as the second parameter:
cols = ["Weight","Height","BootSize","SuitSize","Type"]df2[cols] = df2[cols].replace(['0', 0], np.nan)
data['amount']=data['amount'].replace(0, np.nan)data['duration']=data['duration'].replace(0, np.nan)