Answers for "how to replace a column name in pandas"

15

pandas rename column

df.rename(columns={"old_col1": "new_col1", "old_col2": "new_col2"}, inplace=True)
Posted by: Guest on June-09-2020
15

rename column name pandas dataframe

df.rename(columns={"old_col1": "new_col1", "old_col2": "new_col2"})
Posted by: Guest on May-11-2020
0

dataframe rename column

df = pd.DataFrame({"A": [1, 2, 3], "B": [4, 5, 6]})

# Option 1
df.rename({"A": "a", "B": "c"}, axis=1)

# Option 2
df.rename(columns={"A": "a", "B": "c"})

# Result
   a  c
0  1  4
1  2  5
2  3  6
Posted by: Guest on March-10-2021
1

how to give name to column in pandas

>gapminder.rename(columns={'pop':'population',
                          'lifeExp':'life_exp',
                          'gdpPercap':'gdp_per_cap'}, 
                 inplace=True)
 
>print(gapminder.columns)
 
Index([u'country', u'year', u'population', u'continent', u'life_exp',
       u'gdp_per_cap'],
      dtype='object')
 
>gapminder.head(3)
 
       country  year  population continent  life_exp  gdp_per_cap
0  Afghanistan  1952     8425333      Asia    28.801   779.445314
1  Afghanistan  1957     9240934      Asia    30.332   820.853030
2  Afghanistan  1962    10267083      Asia    31.997   853.100710
Posted by: Guest on May-29-2020
0

rename one dataframe column python in inplace

import pandas as pd

d1 = {'Name': ['Pankaj', 'Lisa', 'David'], 'ID': [1, 2, 3], 'Role': ['CEO', 'Editor', 'Author']}

df = pd.DataFrame(d1)

print('Source DataFrame:\n', df)

df.rename(index={0: '#0', 1: '#1', 2: '#2'}, columns={'Name': 'EmpName', 'ID': 'EmpID', 'Role': 'EmpRole'}, inplace=True)

print('Source DataFrame:\n', df)
Posted by: Guest on May-30-2021

Code answers related to "how to replace a column name in pandas"

Python Answers by Framework

Browse Popular Code Answers by Language