python中多个数据存入同一个xlsx中

pd_writer = pd.ExcelWriter(filename + f'{value_d}_tests.xlsx')
marge_data = []
    for train_size in train_sets:  
       data = pd.read_csv(filename + '.csv',sep=',', header=None).value
       pd_data = pd.DataFrame(data , index=train_sets)
       pd_data.to_excel(pd_writer,sheet_name=f'{no_have}_{way}')
pd_writer.save() # 这里注意这个save()要与close在同一级中
pd_writer.close()