代码如下:
# @Author: BigMoore
# @Time: 2022/3/29 9:42
import importlib
import sys
import os
import pandas as pd
def Profile(dir, profiles):
for lis in os.listdir(dir):
newDir = os.path.join(dir, lis)
if os.path.isfile(newDir):
profiles.append(newDir)
else:
Profile(newDir, profiles)
pass
return profiles
def xlssToxls(dir, xpath, cpath):
profiles = []
Profile(dir, profiles)
print(len(profiles))
# print(profiles)
df = pd.DataFrame()
for table in profiles:
data = pd.read_excel(table)
df = pd.concat([df, data])
# 使用reset_index() 重置索引。drop = True的话,索引会连续计数
df = df.reset_index(drop=True)
df.to_excel(xpath, encoding='utf-8')
df.to_csv(cpath, encoding='utf-8')
if __name__ == '__main__':
importlib.reload(sys)
dir = r'E:\统计\contact\Test'
x_path = r'E:\统计\contact\Test跑出来的文件\test.xlsx'
c_path = r'E:\统计\contact\Test跑出来的文件\test.csv'
# 检测os.path.isfile()函数
# for item in os.listdir(dir):
# newdir = os.path.join(dir, item)
# if os.path.isfile(newdir):
# print(newdir, 'yes')
# else:
# print(newdir, 'no')
# print(os.listdir(dir))
xlssToxls(dir, x_path, c_path)