数据合并

students.xlsx

import pandas as pd
students = pd.read_excel('./students.xlsx', sheet_name='Students')
scores = pd.read_excel('./students.xlsx', sheet_name='Scores')
table = students.merge(scores, how='left', on='ID').fillna(0)
table.Score = table.Score.astype(int)
print(table)