擅长:python、mysql、java
<p>一种解决方案是将空列添加到从Excel文件加载的数据帧中:</p>
<pre><code>columns = ['col1', 'col2', 'col3', 'col4', 'col5']
dfAll = pd.DataFrame(columns=columns)
df= pd.read_excel('FilePath', sheetname='data1') # contains 3 columns i.e col1, col2, col5
columnsOFdf = df.columns
for column in columns:
if column not in columnsOFdf:
df[column] = [""] * df.shape[0]
dfAll.append(df)
</code></pre>