擅长:python、mysql、java
<p>如果<code>21</code>总是紧跟在<code>10</code>之后,您可能会喜欢:</p>
<pre><code>df_shifted = df.shift(-1, axis=0) # df is the original DataFrame you have.
is_ok = (df["#3"] == 10) & (df_shifted["#3"] == 21)
ans = pd.concat([df[is_ok], df_shifted[is_ok]], axis=1).drop(columns="#3")
</code></pre>
<p>这将返回:</p>
<pre><code> #2 #4 #2 #4
1 Bob Eng Jack Tel
6 Rams Mal Venk Mar
</code></pre>