def test08(): INPUTFILE1 = os.path.join(BASE_PATH, 'Student_Score.xlsx') datas = ExcelUntil.readExcelFile(INPUTFILE1, headerRow=0, indexCol='ID') if 'Students' not in datas.keys() and 'Scores' not in datas.keys(): return studentsDatas=datas['Students'] ScoresDatas=datas['Scores'] tabels1=studentsDatas.merge(ScoresDatas,how='left',on='ID').fillna('0') tabels2=studentsDatas.merge(ScoresDatas,how='left',left_on=studentsDatas.index,right_on=ScoresDatas.index).fillna('0') tabels3=studentsDatas.join(ScoresDatas,how='left').fillna('0') print(tabels3)