replace pandas string code example
Example 1: find and replace string dataframe
df['range'] = df['range'].str.replace(',','-')
Example 2: pandas replace word begins with contains
df['sport'] = df.sport.str.replace(r'(^.*ball.*$)', 'ball sport')
df
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: str replace pandas
>>> pd.Series(['foo', 'fuz', np.nan]).str.replace('f.', 'ba', regex=True)
0 bao
1 baz
2 NaN
dtype: object
Example 5: 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