python dataframe replace string in column code example

Example 1: replace column values pandas

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

Example 2: replace values of pandas column

df.loc[df['column'] == 'column_value', 'column'] = 'new_column_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 = df.sport.apply(lambda x: 'ball sport' if 'ball' in x else x)