Answers for "replace data in specific columns with specific values"

pandas replace data in specific columns with specific values

### replace one value ###
df["column"].replace("US","UK") # you can also use numerical values
### replace more than one value ###
df["column"].replace(["man","woman","child"],[1,2,3]) # you can also use numerical values
#   man ==> 1
# woman ==> 2
# child ==> 3

replace values in a column by condition python

df.loc[df['employrate'] > 70, 'employrate'] = 7