【Python】Add header to dataframe | Change column names of dataframe

Add a Header Row to a Pandas DataFrame (3 methods)

• method 1

# add header row when creating DataFrame
df = pd.DataFrame(data = [data_values],
				 columns = ['col_name_1', 'col_name_2', 'col_name_3'])

• method 2

# add header row after creating DataFrame
df = pd.DataFrame(data = [data_values])
df.columns = ['col_name_1', 'col_name_2', 'col_name_3']

• method 3 (use this, cuz always add header row after reading csv)

# add header row when importing CSV
df = pd.read_csv('data.csv',
				names = ['col_name_1', 'col_name_2', 'col_name_3'])

Rename Columns in Pandas (3 methods)

• method 1

# rename specific columns
df.rename(columns = {'old_col_name_1'：'new_col_name_1', 'old_col_name_2'：'new_col_name_2'},
					inplace = True)

• method 2

# rename all columns
df.columns = ['new_col_name_1', 'new_col_name_2']

• method 3 (little use)

# replace specific characters in columns
df.columns = df.columns.str.replace('old_char', 'new_char')

# Example
import pandas as pd
## define DataFrame
df = pd.DataFrame({'$team':['A', 'A', 'A', 'A', 'B', 'B', 'B', 'B'],
                   '$points': [25, 12, 15, 14, 19, 23, 25, 29],
                   '$assists': [5, 7, 7, 9, 12, 9, 9, 4],
                   '$rebounds': [11, 8, 10, 6, 6, 5, 9, 12]})
## list column names
list(df)
['$team', '$points', '$assists', '$rebounds']
## rename $ with blank in every column name
df.columns = df.columns.str.replace('$', '')
## view updated list of column names
list(df)
['team', 'points', 'assists', 'rebounds']

Ref:
https://www.statology.org/pandas-dataframe-header/
https://www.statology.org/pandas-rename-columns/