replace spelling of rows in df python code example

Example 1: replacing values in pandas dataframe

df['coloum'] = df['coloum'].replace(['value_1','valu_2'],'new_value')

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

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