import pandas as pd
d={'name':['edward','margaret'],'sex':['male','female'],'amt':[100,200]}

df=pd.DataFrame(data=d)

df.loc[df['sex']=='female','amt']=-200

df.loc[df['sex']=='female','amt'] *= -1