pandas replace string code example

Example 1: find and replace string dataframe

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

Example 2: replace column values pandas

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

Example 3: pandas replace word begins with contains

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

Example 4: 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 5: str replace pandas

>>> pd.Series(['foo', 'fuz', np.nan]).str.replace('f.', 'ba', regex=True)
0    bao
1    baz
2    NaN
dtype: object