pandas dataframe replace column code example

Example 1: replace column values pandas

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

Example 2: how to change the columns of a dataframe in python

new_columns = {"col1": "1st", "col2": "2nd"}
df_new = df.rename(columns=new_columns)

"""
 col1 | col2 | col3            1st | 2nd | col3
   a  |   d  |	 g              a  |  d  |  g
   b  |   e  |   h		=>      b  |  e  |  h
   c  |   f  |   i              c  |  f  |  i
"""

Example 3: pandas dataframe replace inf

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

Example 4: replace values of pandas column

df.loc[df['column'] == 'column_value', 'column'] = 'new_column_value'

Example 5: how to replace values in column pandas

# this will replace "Boston Celtics" with "Omega Warrior"
df.replace(to_replace ="Boston Celtics",
                 value ="Omega Warrior")