import os
import pandas

data = pandas.read_excel("./个人信息.xls", sheet_name='Sheet1',usecols=['姓名',"性别"])
files = os.listdir("./学生区")

for file in files:
    print(data.loc[int(file[0:3])-1]["姓名"])
    name = data.loc[int(file[0:3])-1]["姓名"]
    sex = data.loc[int(file[0:3])-1]["性别"]
    os.rename(os.path.join("./学生区",file),os.path.join("./学生区",f"{name}_{sex}"))