一、zip文件读取
读取zip文件中的zip文件
with zipfile.ZipFile(file_path, 'r') as zfile:
for name in zfile.namelist():
if name == 'excel.zip': # 视情况而改变条件
zfiledata = BytesIO(zfile.read(name))
with zipfile.ZipFile(zfiledata) as zfile2:
for text_file in zfile2.infolist():
if text_file.filename.endswith('xls'):
fname = text_file.filename.encode('cp437').decode('gbk') # 解决zip文件解压后文件名中文乱码
df = pd.read_excel(zfile2.open(text_file.filename), skiprows=2)
二、解决解压后的文件名乱码问题
fname = text_file.filename.encode('cp437').decode('gbk')