change column name in python code example
Example 1: rename column name pandas dataframe
df.rename(columns={"old_col1": "new_col1", "old_col2": "new_col2"})
Example 2: python: change column name
df = df.rename(columns = {'myvar':'myvar_new'})
Example 3: 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 4: Renaming row value in pandas
# if the row value in column 'is_blue' is 1
# Change the row value to 'Yes'
# otherwise change it to 'No'
df['is_blue'] = df['is_blue'].apply(lambda x: 'Yes' if (x == 1) else 'No')
# You can also use mapping to accomplish the same result
# Warning: Mapping only works once on the same column creates NaN's otherwise
df['is_blue'] = df['is_blue'].map({0: 'No', 1: 'Yes'})
Example 5: give column names to a dataframe
>gapminder.columns = ['country','year','population',
'continent','life_exp','gdp_per_cap']
Example 6: rename column pandas
>>> df.rename({1: 2, 2: 4}, axis='index')
A B
0 1 4
2 2 5
4 3 6