用to_csv()是不行的,会覆盖掉之前写入的表,最终导致excel中只有一个sheet
所以这里用ExcelWriter实现写多个sheet
import pandas as pd
excelWriter = pd.ExcelWriter("test.xlsx")
for index, name in enumerate(names):
df = pd.read_csv(f"data/{name}.csv", encoding='utf-8')
df.to_excel(excel_writer=excelWriter, sheet_name=name, index=None)
excelWriter.save()