<p>查看输入的excel文件的屏幕截图以及打印的数据框,您遇到的问题可能是由于第二行和第三行中的合并单元格造成的。在</p>
<p>我建议使用docs(<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_excel.html" rel="nofollow noreferrer">Link Here</a>)中概述的<code>pandas.DataFrame.to_excel</code>的一些参数。尤其是,<code>header</code>和{<cd3>}应该对您有所帮助。在</p>
<p>我在下面提供了一个例子,在这个例子中,我创建了一个excel文件(.xlsx),它复制了合并单元格的问题。然后,我将.xlsx复制为.xls,并使用<code>pandas.DataFrame.to_excel</code>和{<cd3>}来读它。在</p>
<pre><code>import pandas as pd
import numpy as np
import shutil
# Creating a dataframe and saving as test.xlsx in current directory
df = pd.DataFrame(np.random.randn(10, 3), columns=list('ABC'))
writer = pd.ExcelWriter('test.xlsx', engine='xlsxwriter')
df.to_excel(writer, sheet_name='Sheet1', startrow=3, index=False,
header=False)
wb = writer.book
ws = writer.sheets['Sheet1']
ws.merge_range('A1:C1', 'Large Merged Cell in first Row')
ws.merge_range('A2:A3', 'A')
ws.merge_range('B2:B3', 'B')
ws.merge_range('C2:C3', 'C')
wb.close()
print(df)
#copying test.xlsx as a .xls file
shutil.copy(r"test.xlsx" , r"test.xls")
new_df = pd.read_excel('test.xls', header = 0, skiprows = [0,2])
print(new_df)
</code></pre>
<p>期望测试.xls文件:
<a href="https://i.stack.imgur.com/olFqY.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/olFqY.jpg" alt="Expected test.xls"/></a></p>
<p><code>print(new_df)</code>应显示:</p>
^{pr2}$