表格中含有中文
import os
import pandas as pd
import numpy as np
dir = "E:/loan data"#设置工作路径
#新建列表,存放文件名
filename = []
#新建列表,存放每个文件数据框(每一个excel读取后存放在数据框)
frames = []
#遍历
for root, dirs, files in os.walk(dir):
for file in files:
#print(os.path.join(root,file))
filename.append(os.path.join(root,file))
f = open(os.path.join(root,file),encoding='gb18030',errors='ignore')
df = pd.read_csv(f) #转换成DataFrame
frames