擅长:python、mysql、java
<h2>给定您的数据帧<code>data</code>:</h2>
<ul>
<li>迭代每个唯一ID,并为这些值分割数据帧,然后保存到文件中</李>
</ul>
<pre class="lang-py prettyprint-override"><code>import pandas as pd
with pd.ExcelWriter('data.xlsx') as writer:
for i, value in enumerate(data.ID.unique(), start=1):
data[data.ID == value].to_excel(writer, index=False, sheet_name=f'Sheet{i}')
</code></pre>
<ul>
<li>我想你最好用ID值来命名每张纸,而不是<code>Sheet1</code>等等。例如<code>sheet_name=f'{value}'</code>
<ul>
<li>这将允许您识别每个ID所在的工作表</李>
<li><a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_excel.html" rel="nofollow noreferrer">^{<cd4>}</a></li>
</ul></li>
</ul>
<pre class="lang-py prettyprint-override"><code>import pandas as pd
with pd.ExcelWriter('data.xlsx') as writer:
for value in data.ID.unique():
data[data.ID == value].to_excel(writer, index=False, sheet_name=f'{value}')
</code></pre>