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 = 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