擅长:python、mysql、java
<p>你是说像这样的事情吗</p>
<pre><code>>>> x = df.loc[(df['#3'].eq(10) & df['#3'].shift(-1).eq(21)) | (df['#3'].shift().eq(10) & df['#3'].eq(21))]
>>> x.groupby(np.arange(len(x)) // 2).apply(lambda x: pd.DataFrame(x.drop(["#1", "#3"], axis=1).to_numpy().flatten()).T).reset_index(drop=True).rename(lambda x: f'#{x + 1}', axis=1)
#1 #2 #3 #4
0 Bob Eng Jack Tel
1 Rams Mal Venk Mar
>>>
</code></pre>