# python实现VLOOKUP
import pandas as pd
import os
os.chdir(r'F:\ant_python\代码03_Python使用Pandas入门数据分析\ant-learn-pandas')
df_grade = pd.read_excel('./course_datas/c23_excel_vlookup/学生成绩表.xlsx')
df_sinfo = pd.read_excel('./course_datas/c23_excel_vlookup/学生信息表.xlsx')
df_grade.head()
df_sinfo.head()
# 只筛选第二个表的少量的列
df_sinfo = df_sinfo[["学号", "姓名", "性别"]]
df_merge = pd.merge(left=df_grade,right=df_sinfo,on='学号')
# 调整顺序
new_columns = df_merge.columns.to_list()
for name in ['姓名','性别'][::-1]:
new_columns.remove(name)
new_columns.insert(new_columns.index('学号')+1,name)
new_columns
df_merge = df_merge.reindex(columns=new_columns)