replace multiple text in particular column python code example

Example 1: replace multiple values in pandas column

df = pd.DataFrame({'a':['Small', 'Medium', 'High']})

In [22]: df
Out[22]: 
        a
0   Small
1  Medium
2    High

[3 rows x 1 columns]

df.replace({'a' : { 'Medium' : 2, 'Small' : 1, 'High' : 3 }})

Example 2: replace values in a column by condition python

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