replace function pandas code example

Example 1: replace column values pandas

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

Example 2: pandas dataframe replace inf

df.replace([np.inf, -np.inf], np.nan)

Example 3: pandas replace word begins with contains

df.sport = df.sport.apply(lambda x: 'ball sport' if 'ball' in x else x)

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