最近用pandas批量读入xls文件:
import pandas as pd
import glob,os
filelist1 = os.listdir('dataset1/1')
for filename in filelist1:
file = pd.read_excel('dataset1/1/{}'.format(filename),engine='xlrd')
报错:
最后发现原因是,在MAC 的每一个文件夹里,都有一个隐藏的文件,叫做 ‘.DS_Store’。所以代码改成下面这样就解决了:
import pandas as pd
import glob,os
filelist1 = os.listdir('dataset1/1')
for filename in filelist1:
if(filename != '.DS_Store'):
file = pd.read_excel('dataset1/1/{}'.format(filename),engine='xlrd')