回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我想知道如何在每组后面插入一个空行和一个带索引的行。
我能够插入一个空行(感谢上面的引用),但是,我很难想出如何插入另一个带有索引的行</p>
<p>原件:</p>
<pre>
+------+---------+-------+--+
| id | country | score | |
+------+---------+-------+--+
| 1011 | JPN | 5 | |
| 1011 | JPN | 5 | |
| 1011 | NZ | 4 | |
| 1011 | NZ | 5 | |
| 1012 | NZ | 5 | |
| 1012 | AUS | 6 | |
| 1012 | NZ | 6 | |
| 1013 | AUS | 5 | |
| 1013 | AUS | 5 | |
+------+---------+-------+--+
</pre>
<p>插入一个空行</p>
<pre>
+------+---------+-------+
| id | country | score |
+------+---------+-------+
| 1011 | JPN | 5 |
| 1011 | JPN | 5 |
| 1011 | NZ | 4 |
| 1011 | NZ | 5 |
| | | |
| 1012 | NZ | 5 |
| 1012 | AUS | 6 |
| 1012 | NZ | 6 |
| | | |
| 1013 | AUS | 5 |
| 1013 | AUS | 5 |
+------+---------+-------+
</pre>
<p>所需输出:</p>
<pre>
+------+---------+-------+
| id | country | score |
+------+---------+-------+
| 1011 | JPN | 5 |
| 1011 | JPN | 5 |
| 1011 | NZ | 4 |
| 1011 | NZ | 5 |
| | | |
| id | country | score |
| 1012 | NZ | 5 |
| 1012 | AUS | 6 |
| 1012 | NZ | 6 |
| | | |
| id | country | score |
| 1013 | AUS | 5 |
| 1013 | AUS | 5 |
+------+---------+-------+
</pre>
<p>原始DF:</p>
<pre><code>import pandas as pd
import numpy as np
data = {'id':[1011,1011,1011,1011,1012,1012,1012,1013,1013],
'country':[JPN,JPN,NZ,NZ,NZ,AUS,NZ,AUS,AUS]
,'score':[5,5,4,5,5,6,6,5,5]}
df = pd.DataFrame(data)
</code></pre>
<p>插入空行的DF:</p>
<pre><code>df1= df.groupby('id').apply(lambda d: d.append({'id': d.name}, ignore_index=True).astype({'id': int})).reset_index(drop=True)
</code></pre>
<p>非常感谢
问候</p>