change the name of a column pandas code example

Example 1: python: change column name

df = df.rename(columns = {'myvar':'myvar_new'})

Example 2: rename column pandas

df_new = df.rename(columns={'A': 'a'}, index={'ONE': 'one'})
print(df_new)
#         a   B   C
# one    11  12  13
# TWO    21  22  23
# THREE  31  32  33

print(df)
#         A   B   C
# ONE    11  12  13
# TWO    21  22  23
# THREE  31  32  33

Example 3: 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 4: name columns pandas

>gapminder.columns = ['country','year','population',
                     'continent','life_exp','gdp_per_cap']

Example 5: change column names pandas

df.columns = ['A','B']