replace columns names 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 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 3: df change column names

df.rename(columns={"A": "a", "B": "b", "C": "c"},
errors="raise", inplace=True)

Example 4: df.rename(index=str, columns={"A": "a", "C": "c"}) what does index=str means

>>> df.index
RangeIndex(start=0, stop=3, step=1)
>>> df.rename(index=str).index
Index(['0', '1', '2'], dtype='object')