擅长:python、mysql、java
<p>虽然@anky的解决方案在理想情况下是正确的,但我认为也可以通过以下方式实现:</p>
<p>逐个导入CSV文件后,请执行以下操作:</p>
<pre><code>filename1 = os.path.basename("path/to/file/QB305707.csv")
csv1Data = pd.read_csv(filename1)
# Assuming you did this with different variable names for each file
dfcsv1Data['filename'] = filename1
# Do this for all three DFs and simply concat / append all three dataframes together
</code></pre>