6.3. DataFrame Rename
df.rename(columns={...})- rename column namesdf.rename(index={...})- rename indexdf.columns = [...]- set column namesdf.index = [...]- set index
6.3.1. SetUp
>>> import pandas as pd
>>>
>>>
>>> df = pd.DataFrame([
... {'firstname': 'Alice', 'lastname': 'Apricot', 'age': 30},
... {'firstname': 'Bob', 'lastname': 'Blackthorn', 'age': 31},
... {'firstname': 'Carol', 'lastname': 'Corn', 'age': 32},
... ])
>>>
>>> df
firstname lastname age
0 Alice Apricot 30
1 Bob Blackthorn 31
2 Carol Corn 32
6.3.2. Rename Columns
df.rename(columns={...})- rename column names
>>> df = pd.DataFrame([
... {'firstname': 'Alice', 'lastname': 'Apricot', 'age': 30},
... {'firstname': 'Bob', 'lastname': 'Blackthorn', 'age': 31},
... {'firstname': 'Carol', 'lastname': 'Corn', 'age': 32},
... ])
>>>
>>> df
firstname lastname age
0 Alice Apricot 30
1 Bob Blackthorn 31
2 Carol Corn 32
>>> df.rename(columns={
... 'firstname': 'fname',
... 'lastname': 'lname',
... 'age': 'age'
... })
fname lname age
0 Alice Apricot 30
1 Bob Blackthorn 31
2 Carol Corn 32
6.3.3. Rename Index
df.rename(index={...})- rename index
>>> df = pd.DataFrame([
... {'firstname': 'Alice', 'lastname': 'Apricot', 'age': 30},
... {'firstname': 'Bob', 'lastname': 'Blackthorn', 'age': 31},
... {'firstname': 'Carol', 'lastname': 'Corn', 'age': 32},
... ])
>>>
>>> df
firstname lastname age
0 Alice Apricot 30
1 Bob Blackthorn 31
2 Carol Corn 32
>>> df.rename(index={
... 0: 'a',
... 1: 'b',
... 2: 'c'
... })
firstname lastname age
a Alice Apricot 30
b Bob Blackthorn 31
c Carol Corn 32
6.3.4. Set Columns
df.columns = [...]- set column names
>>> df = pd.DataFrame([
... {'firstname': 'Alice', 'lastname': 'Apricot', 'age': 30},
... {'firstname': 'Bob', 'lastname': 'Blackthorn', 'age': 31},
... {'firstname': 'Carol', 'lastname': 'Corn', 'age': 32},
... ])
>>>
>>> df
firstname lastname age
0 Alice Apricot 30
1 Bob Blackthorn 31
2 Carol Corn 32
>>> df.columns = ['fname', 'lname', 'age']
>>>
>>> df
fname lname age
0 Alice Apricot 30
1 Bob Blackthorn 31
2 Carol Corn 32
6.3.5. Set Index
df.index = [...]- set index
>>> df = pd.DataFrame([
... {'firstname': 'Alice', 'lastname': 'Apricot', 'age': 30},
... {'firstname': 'Bob', 'lastname': 'Blackthorn', 'age': 31},
... {'firstname': 'Carol', 'lastname': 'Corn', 'age': 32},
... ])
>>>
>>> df
firstname lastname age
0 Alice Apricot 30
1 Bob Blackthorn 31
2 Carol Corn 32
>>> df.index = ['a', 'b', 'c']
>>>
>>> df
firstname lastname age
a Alice Apricot 30
b Bob Blackthorn 31
c Carol Corn 32