有这样一个数据集:
两张表用ID关联着
一、通过ID联合查询
import pandas as pd
students = pd.read_excel("C:/Users/Administrator/Desktop/Student_Score.xlsx",sheet_name="Students")
scores = pd.read_excel("C:/Users/Administrator/Desktop/Student_Score.xlsx",sheet_name='Scores')
data = pd.merge(students,scores)
print(data)
结果:
说明:1.merge如果不指定基于哪个字段,会自动在列中查找相同的字段进行匹配
2.如果在读取时,设置了index