用python淘汰excel篇：批量导入一个文件夹里的xlsx文件并汇总导出csv文件
import pandas as pd
import os
os.chdir(r'C:/Python39/jinsai/dataset/alltest/')
data = []
for excel in os.listdir('.'):
data.append(pd.read_excel('C:/Python39/jinsai/dataset/alltest/'+ excel))
excel_all = pd.concat(data)
excel_all.to_csv('c:/python39/jinsai/dataset/alltest/汇总表.csv', index=False)