&emsp读取文件夹下同一类型的文件
import os
import re
import sas7bdat
from sas7bdat import SAS7BDAT
path=str(r'C:\Users\Peter Heinz\Desktop\data')
path_name=os.listdir(path)
for i in range (0,len(path_name)):
file=os.listdir(path+str('\\')+str(path_name[i]))
path_name_new=str(path_name[i])
pat=r'(.*).sas7bdat'
for j in range (0,len(file)):
data_name=re.findall(pat,file[j])
if data_name != []:
data_name=data_name
#读取sas7bdat文件,并转为gb2312编码
f = SAS7BDAT(path+str('\\')+path_name_new+str('\\')+str(data_name[0])+'.sas7bdat',
encoding = "gb2312").to_data_frame()
#转为xlsx格式
f.to_excel(r'C:\Users\Peter Heinz\Desktop\transdata\{}.xlsx'.format(data_name[0]))
else:
j=j+1