replace column names in pandas code example

Example 1: change column name df

>>> df = pd.DataFrame({"A": [1, 2, 3], "B": [4, 5, 6]})
>>> df.rename(columns={"A": "a", "B": "c"})
   a  c
0  1  4
1  2  5
2  3  6

Example 2: replace column values pandas

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

Example 3: change name of column pandas

#df.rename() will only return a new df with the new headers
#df = df.rename() will change the heders of the current dataframe 
df = df.rename(columns={"old_col1": "new_col1", "old_col2": "new_col2"})

Example 4: replace values of pandas column

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

Example 5: how to give name to column in pandas

>gapminder.rename(columns={'pop':'population',
                          'lifeExp':'life_exp',
                          'gdpPercap':'gdp_per_cap'}, 
                 inplace=True)
 
>print(gapminder.columns)
 
Index([u'country', u'year', u'population', u'continent', u'life_exp',
       u'gdp_per_cap'],
      dtype='object')
 
>gapminder.head(3)
 
       country  year  population continent  life_exp  gdp_per_cap
0  Afghanistan  1952     8425333      Asia    28.801   779.445314
1  Afghanistan  1957     9240934      Asia    30.332   820.853030
2  Afghanistan  1962    10267083      Asia    31.997   853.100710

Example 6: rename column pandas

>>> df.rename(str.lower, axis='columns')
   a  b
0  1  4
1  2  5
2  3  6