replace string pandas column code example

Example 1: replace column values pandas

df['column'] = df['column'].str.replace(',','-')
df

Example 2: replacing values in pandas dataframe

df['coloum'] = df['coloum'].replace(['value_1','valu_2'],'new_value')

Example 3: pandas replace word begins with contains

In [71]:
df.loc[df['sport'].str.contains('ball'), 'sport'] = 'ball sport'
df

Out[71]:
    name       sport
0    Bob      tennis
1   Jane  ball sport
2  Alice  ball sport

Example 4: pandas replace word begins with contains

df.sport.str.replace(r'(^.*ball.*$)', 'ball sport')

0        tennis
1    ball sport
2    ball sport
Name: sport, dtype: object