Pandas：常见的转换函数(rename,set_index,reset_index)

1 rename()

df = pd.DataFrame(
{'name':['jack','alice','tom','bob'],'age':[20,30,40,60],'gender':['female','male','female','male']
})df

修改列名

df.rename(columns = {"age":"年龄"})

修改索引

df.rename(index = {0:10})

也可以直接通过属性修改：

df.index = [5,6,7,8]
df.columns = ["姓名","年龄","性别"]
df

2 set_index()

df = pd.DataFrame(
{'name':['jack','alice','tom','bob'],'age':[20,30,40,60],'gender':['female','male','female','male'] 
})df.set_index("name",inplace = True)
# inplace设置为True，会直接修改df本身
df

3 reset_index()

df = pd.DataFrame(
{'name':['jack','alice','tom','bob'],'age':[20,30,40,60],'gender':['female','male','female','male'] 
})df.set_index("name",inplace = True)
df.reset_index(inplace = True)
df