How to rename columns in Pandas ?

Question

How to rename columns in Pandas ?

I have a DataFrame using Pandas and column labels that I need to edit to replace the original column labels.

I want to change the column names in a DataFrame A where the original column names are:



['$a', '$b', '$c', '$d', '$e']

to



['a', 'b', 'c', 'd', 'e'].

I have the edited column names stored it in a list, but I don't know how to replace the column names.

dataframe pandas python

4 years ago by bhumi2201

2 Answers

Login / Signup to Answer the Question.

Login Signup

**RoliMishra** · Answer 1 · 2021-05-04T16:11:47

Just assign it to the .columns attribute:

>>> df = pd.DataFrame({'$a':[1,2], '$b': [10,20]})

>>> df

   $a  $b

0   1  10

1   2  20



>>> df.columns = ['a', 'b']

>>> df

   a   b

0  1  10

1  2  20

**sandhya6gczb** · Answer 2 · 2021-05-12T12:41:51

sandhya6gczb

For renaming the columns use



df.rename(columns={'$a': 'a', '$b': 'b', '$c': 'c', '$d': 'd', '$e': 'e'}, inplace=True)

4 years ago

C TUTORIAL

C PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

C++ TUTORIAL

C++ PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

PYTHON TUTORIAL

PYTHON HOW TOS

INTERVIEW TESTS

EXECUTE CODE

JAVA TUTORIAL

JAVA CODE EXAMPLES

SPRING TUTORIAL

MORE IN JAVA

COMPUTER ARCHITECTURE

COMPUTER NETWORK

OPERATING SYSTEM

DBMS & SQL

PL/SQL

MongoDB

EXECUTE SQL

ANDROID DEVELOPMENT

GO LANGUAGE

LINUX

DOCKER

HTML TAGS (A to Z)

CSS REFERENCES

SASS/SCSS

KOTLIN

GAME DEVELOPMENT

PHP

GIT GUIDE

JAVASCRIPT

ADVANCED DSA

How to rename columns in Pandas ?

2 Answers

Login / Signup to Answer the Question.