【pandas】把多个CSV写到一个Excel中

import pandas as pd
import xlsxwriter
# 把多个CSV写到一个Excel中
rp = r'D:\工作表\test.xlsx'
writer = pd.ExcelWriter(rp,engine = 'xlsxwriter')
rp1 = r'D:\工作表\test1.csv'
df = pd.read_csv(rp1,encoding = 'ANSI',engine = 'python')
df.to_excel(writer,sheet_name = 'test1',index = False)
rp2 = r'D:\工作表\test2.csv'
df1 = pd.read_csv(rp2,encoding = 'ANSI',engine = 'python')
df1.to_excel(writer,sheet_name = 'test2',index = False)
writer.save()
writer.close()
print('finished')