擅长:python、mysql、java
<p>为了完整起见,我想展示我最终使用的解决方案,非常接近Khelili的建议,只做了一些调整以适应我的特定代码,包括在这个阶段不创建数据帧</p>
<pre><code>import os
import pandas as pd
import openpyxl as excel
import glob
#setting up path
path = 'data_inputs'
extension = 'xlsx'
os.chdir(path)
files = [i for i in glob.glob('*.{}'.format(extension))]
#Grouping files - brings multiple files of same type together in a list
wild_groups = ([s for s in files if "wild" in s])
domestic_groups = ([s for s in files if "domestic" in s])
#Sets up a dictionary associated with the file groupings to be called in another module
file_names = {"WILD":wild_groups, "DOMESTIC":domestic_groups}
...
</code></pre>