擅长:python、mysql、java
<p>只需将<code>writer.save()</code>移出<code>for</code>循环:</p>
<pre><code>writer = pd.ExcelWriter('output.xlsx', engine='xlsxwriter')
workbook = writer.book
web_ClassID=df_stag["Web-Class ID"].unique()
for data_id, df in df_stag.groupby('Web-Class ID'):
for workbook_Id in web_ClassID:
if workbook_Id == data_id:
for index, col in enumerate(df):
df.to_excel(writer,sheet_name=workbook_Id,index=False )
writer.save()
workbook.close()
</code></pre>
<p>对于较短的代码,只需迭代过滤,而不需要<em>工作簿</em>对象:</p>
^{pr2}$