pandas----使用主键连接 merge()

import pandas as pd
import openpyxl
df1 = pd.DataFrame({"学号": ['201907040332', '201907040333', '202007040215'],
"姓名": ['李昊', '陈铮', '王庚戌'],
"性别": ["男", "男", "男"]})
print(df1)
df2 = pd.DataFrame({"学号": ['201907040332', '201907040333', '202007040215'],
"程序设计基础成绩": [89, 92, 87]})
print(df2)
arr = pd.merge(df1, df2, on="学号")
print(arr)
arr.to_excel("E:/21741班成绩表.xlsx")