擅长:python、mysql、java
<p>我会把它们解析成DataFrame的字典:</p>
<pre><code>import os
import glob
import pandas as pd
files = glob.glob('/path/to/*.xlsx')
dfs = {}
for f in files:
dfs[os.path.splitext(os.path.basename(f))[0]] = pd.read_excel(f)
</code></pre>
<p>然后您可以将它们作为普通字典元素进行访问:</p>
^{pr2}$
<p>等等</p>