Python 批量读取文件夹中的excel

path=r'D:\20201015'
files=os.listdir(path)

alldata=pd.DataFrame()

for file in files[1:-1]:
#     print(file)
    data=pd.read_csv(file,header=None,error_bad_lines=False,encoding='utf-8')
#     data=data[[0,4,11]]
#     data.columns=['applyId','sj','desc']
    alldata=alldata.append(data)
alldata.head()