Python pandas 处理数据的一些技巧与实现

 

 

 

 

 

 

 

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)

 

 

 

 

 

 

 

参考：https://pandas.pydata.org/pandas-docs/stable/