Pandas — Indexing

Set index

import pandas as pd

df = pd.DataFrame({'name': ['Alice', 'Bob'], 'age': [25, 30]})
df = df.set_index('name')

Reset index

df = df.reset_index()

MultiIndex

arrays = [['A', 'A', 'B', 'B'], ['one', 'two', 'one', 'two']]
index = pd.MultiIndex.from_arrays(arrays, names=['first', 'second'])
df = pd.DataFrame({'data': [1, 2, 3, 4]}, index=index)

Reindex

df = df.reindex(['Alice', 'Bob', 'Charlie'])

Rename

df = df.rename(columns={'name': '姓名', 'age': '年龄'})

Mini Practice

1. Set and reset index
2. Create MultiIndex
3. Reindex data
4. Rename columns

Up Next

Continue with Missing Data - Handling NaN values.