擅长:python、mysql、java
<p>@Kardu<a href="https://stackoverflow.com/questions/20906474/import-multiple-csv-files-into-pandas-and-concatenate-into-one-dataframe">This</a>将帮助您以简洁的方式完成这项工作,并且还有许多对其他备选方案有用的注释</p>
<p>同样,受同一篇文章的启发,这应该会有所帮助</p>
<pre><code>import pandas as pd
import glob
path = r'C:\' # use your path
all_files = glob.glob(path + "/Answer*.xlsx")
li = []
for filename in all_files:
df = pd.read_excel(filename, index_col=None, header=0)
li.append(df)
frame = pd.concat(li, axis=0, ignore_index=True)
</code></pre>