/Python/How to rename columns in Pandas DataFrame

How to rename columns in Pandas DataFrame

Rename columns pandas

df.rename(columns={'oldName1': 'newName1',
                   'oldName2': 'newName2'},
          inplace=True, errors='raise')
# Make sure you set inplace to True if you want the change
# to be applied to the dataframe

Pandas dataframe column rename

>>> 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

Source: pandas.pydata.org

Rename df column

import pandas as pd
data = pd.read_csv(file)
data.rename(columns={'original':'new_name'}, inplace=True)

Pandas dataframe rename column

df = df.rename(columns={'oldName1': 'newName1', 'oldName2': 'newName2'})
# Or rename the existing DataFrame (rather than creating a copy) 
df.rename(columns={'oldName1': 'newName1', 'oldName2': 'newName2'}, inplace=True)

Source: stackoverflow.com

How to rename columns in pandas dataframe

energy = energy.rename(columns={2: 'Country', 3: 'Energy Supply' , 4:'Energy Supply per Capita',5:'% Renewable'})

How to rename columns in Pandas DataFrame

# import pandas library
import pandas as pd

# create pandas DataFrame
df = pd.DataFrame({'team': ['India', 'South Africa', 'New Zealand', 'England'],
                   'points': ['10', '8', '3', '5'],
                   'runrate': ['0.5', '1.4', '2', '-0.6'],
                   'wins': ['5', '4', '2', '2']})

# print the column names of DataFrame
print(list(df))

# rename the column names of DataFrame
df.rename(columns={'points': 'total_points',
          'runrate': 'run_rate'}, inplace=True)

# print the new column names of DataFrame
print(list(df))

Source: itsmycode.com

Similar codes

31 votes130 views6 answers
Python string remove whitespace
Python
3 votes131 views1 answer
Maping value to data in pandas dataframe
Python
0 vote78 views2 answers
Rename second column pandas
Python
0 vote82 views2 answers
Python del list
Python
1 vote134 views1 answer
How to make a blank window open up in python
Python
-1 vote119 views2 answers
Dd-mm-yy to yyyy-mm-dd in python
Python
4 votes128 views2 answers
How to get runtime of a function in python
Python
0 vote124 views1 answer
Matplotlib colorbar reverse direction
Python
0 vote137 views1 answer
Multi-line comments Python Example
Python
91 votes120 views6 answers
Time.sleep
Python