擅长:python、mysql、java
<p>尝试添加具有以下AutoStudio ID的新列:</p>
<pre><code>df['next'] = df.AutoStudyID.shift(-1)
df
AutoStudyID DiagDate DiagName next
0 34 2010-09-23 Lung 34
1 34 2001-01-01 Skin 48
2 48 2008-01-01 Brain NaN
</code></pre>
<p>每一行都会有下一个的id。行应按AutoStudyID排序。你知道吗</p>
<p>您也可以尝试按AutoStudio ID分组:</p>
<pre><code>df.groupby('AutoStudyID')
</code></pre>
<p>例如:</p>
<pre><code>for group in df.groupby('AutoStudyID'):
print(group)
</code></pre>
<p>有了这些小组,你就可以做你需要的事:</p>
<pre><code>('34', AutoStudyID DiagDate DiagName next
0 34 2010-09-23 Lung 34
1 34 2001-01-01 Skin 48)
('48', AutoStudyID DiagDate DiagName next
2 48 2008-01-01 Brain NaN)
</code></pre>