擅长:python、mysql、java
<p>尝试:</p>
<pre class="lang-py prettyprint-override"><code>mask = df["#3"].eq(21) & df["#3"].shift().eq(10)
mask = mask.shift(-1).fillna(False) | mask
x = (
df[mask]
.groupby(np.arange(mask.sum()) // 2)
.apply(lambda x: list(x["#2"]) + list(x["#4"]))
).apply(pd.Series)
x.columns = [f"#{x+2}" for x in x.columns]
x = x.reset_index().rename(columns={"index": "#1"})
x["#1"] += 1
print(x)
</code></pre>
<p>印刷品:</p>
<pre class="lang-none prettyprint-override"><code> #1 #2 #3 #4 #5
0 1 Bob Jack Eng Tel
1 2 Rams Venk Mal Mar
</code></pre>