pandas 索引

import pandas as pd
df = pd.DataFrame({"学号": [1001,1002,1003,1004,1005],
                   "name": ["A","B","C","D","E"],
                 "生日": ["1990/01/02","1992/02/05","1990/05/06","1991/05/30","1992/05/03"],
                  "性别": ["boy","girl","girl","boy","girl"],
                   "数学": [56,67,47,87,47]
                  })

默认使用range_index(0,1,2,3,…n)作为索引

1.创建索引

1)使用指定字段创建索引

df = df.set_index("生日") # 将生日字段设为索引
df.index=pd.to_datetime(df.index) # 并将索引的类型指定为时间格式

2）重新索引

df.reset_index() #重新索引

2.更改索引

1）更改索引名

df.rename_axis("name") #更改索引名

2. 更改索引值

df = pd.DataFrame({"A": [1, 2, 3], "B": [4, 5, 6]})
df.rename(index={0:3,1:4,2:5}, columns={"A": "a", "C": "c"})

3.删除索引

df.reset_index() #将索引删除，作为普通列，并从新使用[0,1,2...n]作为索引

其他

df.sort_index() #按索引排序