pandas多表联合join及merge
students = pd.read_excel('Student_Score.xlsx',sheet_name='Students',index_col='ID')scores = pd.read_excel('Student_score.xlsx',sheet_name='Scores',index_col='ID')# #merge多表联合how='left'表示不管对不对，按照左边的表保留数据# table = students.merge(scores,how='left',left_
