panda search replace code example

Example 1: replace column values pandas

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

Example 2: pandas replace word begins with contains

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

Example 3: pandas find fifth caracter in field and change cell based on that number

data['result'] = data['result'].map(lambda x: x.lstrip('+-').rstrip('aAbBcC'))