how to replace values in pandas dataframe code example
Example 1: replace column values pandas
df['column'] = df['column'].str.replace(',','-')
df
Example 2: replacing values in pandas dataframe
df['coloum'] = df['coloum'].replace(['value_1','valu_2'],'new_value')
Example 3: replace values of pandas column
df.loc[df['column'] == 'column_value', 'column'] = 'new_column_value'
Example 4: pandas replace values from another dataframe
In [36]:
df['Group'] = df['Group'].map(df1.set_index('Group')['Hotel'])
df
Out[36]:
Date Group Family Bonus
0 2011-06-09 Jamel Laavin 456
1 2011-07-09 Frank Grendy 679
2 2011-09-10 Luxy Fantol 431
3 2011-11-02 Frank Gondow 569