回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我想提取组中每个数据帧的行,并从中创建新的数据帧,这样一个新的数据帧只包含组的第一行,另一个新的数据帧包含第二行,另一个包含第三行,依此类推。。例如,我的数据帧是:</p>
<pre><code>raw_data = {'regiment': ['Nighthawks', 'Nighthawks', 'Nighthawks', 'Nighthawks', 'Dragoons', 'Dragoons', 'Dragoons', 'Dragoons', 'Scouts', 'Scouts', 'Scouts', 'Scouts'],
'name': ['Miller', 'Jacobson', 'Ali', 'Milner', 'Cooze', 'Jacon', 'Ryaner', 'Sone', 'Sloan', 'Piger', 'Riani', 'Ali'],
'preTestScore': [4, 24, 31, 2, 3, 4, 24, 31, 2, 3, 2, 3],
'postTestScore': [25, 94, 57, 62, 70, 25, 94, 57, 62, 70, 62, 70]}
df = pd.DataFrame(raw_data, columns = ['regiment', 'name', 'preTestScore', 'postTestScore'])
df
regiment name preTestScore postTestScore
0 Nighthawks Miller 4 25
1 Nighthawks Jacobson 24 94
2 Nighthawks Ali 31 57
3 Nighthawks Milner 2 62
4 Dragoons Cooze 3 70
5 Dragoons Jacon 4 25
6 Dragoons Ryaner 24 94
7 Dragoons Sone 31 57
8 Scouts Sloan 2 62
9 Scouts Piger 3 70
10 Scouts Riani 2 62
11 Scouts Ali 3 70
</code></pre>
<p>我把它归为:</p>
<pre><code>gb = df.groupby("regiment")
regiment name preTestScore postTestScore
8 Scouts Sloan 2 62
9 Scouts Piger 3 70
10 Scouts Riani 2 62
11 Scouts Ali 3 70
------------------
regiment name preTestScore postTestScore
0 Nighthawks Miller 4 25
1 Nighthawks Jacobson 24 94
2 Nighthawks Ali 31 57
3 Nighthawks Milner 2 62
------------------
regiment name preTestScore postTestScore
4 Dragoons Cooze 3 70
5 Dragoons Jacon 4 25
6 Dragoons Ryaner 24 94
7 Dragoons Sone 31 57
------------------
</code></pre>
<p>我想创建数据帧,例如:</p>
<p>具有第一行的数据帧:</p>
<pre><code> regiment name preTestScore postTestScore
8 Scouts Sloan 2 62
0 Nighthawks Miller 4 25
4 Dragoons Cooze 3 70
</code></pre>
<p>具有第二行的数据帧:</p>
<pre><code> regiment name preTestScore postTestScore
9 Scouts Piger 3 70
1 Nighthawks Jacobson 24 94
5 Dragoons Jacon 4 25
</code></pre>
<p>等等。你知道吗</p>
<p>我想用组。应用()但我不太确定。你知道吗</p>
<p>非常感谢!你知道吗</p>