擅长:python、mysql、java
<p>您可以通过<a href="https://docs.python.org/3/library/os.path.html#os.path.splitext" rel="nofollow noreferrer">^{<cd1>}</a>从完整路径中提取文件名。然后用<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.assign.html" rel="nofollow noreferrer">^{<cd2>}</a>换行:</p>
<pre><code>import os
def extract_name(x):
return os.path.splitext(fp)[0].split('_')[0]
dfs = [pd.read_excel(fp).assign(row1=extract_name(fp)) for fp in all_files]
</code></pre>