change colnames pandas code example

Example 1: python how to rename columns in pandas dataframe

# Basic syntax:
# Assign column names to a Pandas dataframe:
pandas_dataframe.columns = ['list', 'of', 'column', 'names']
# Note, the list of column names must equal the number of columns in the
# 	dataframe and order matters

# Rename specific column names of a Pandas dataframe:
pandas_dataframe.rename(columns={'column_name_to_change':'new_name'})
# Note, with this approach, you can specify just the names you want to
# 	change and the order doesn't matter

# For rows, use "index". E.g.:
pandas_dataframe.index = ['list', 'of', 'row', 'names']
pandas_dataframe.rename(index={'row_name_to_change':'new_name'})

Example 2: 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 3: how to change column name in pandas

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

Example 4: rename column pandas

>>> df.rename({1: 2, 2: 4}, axis='index')
   A  B
0  1  4
2  2  5
4  3  6

Example 5: change column names pandas

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