python同一文件三表vlookup

python同一文件三表vlookup

1.文件
學生表

課程表
學生選課表

2.代碼實現

import pandas as pd

df=pd.read_excel("python.xlsx",sheet_name=None)
df_student=df['学生']
df_course=df['课程']
df_select=df['选课']
#print(df_student)
#print(df_course)
#print(df_select)
# 三表关联
df_merge=pd.merge(
    left=df_select,
    right=df_student,
    left_on="选课学号",
    right_on="学号"
).drop(columns=["学号"])
# print(df_merge)
df_merge=pd.merge(
    left=df_merge,
    right=df_course,
    left_on="选课课程",
    right_on="课程ID"
).drop(columns=["课程ID"])
#print(df_merge)
df_merge.to_excel("三表关联后表.xlsx",index=False) # 另存為excel文件
print("输出成功!")

3.最終效果