擅长:python、mysql、java
<p>您可以将<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.core.groupby.GroupBy.agg.html" rel="nofollow noreferrer"><strong>^{<cd1>}</strong></a>与<code>first</code>和<code>last</code>一起使用</p>
<pre class="lang-py prettyprint-override"><code>g = df["Event"].ne(df["Event"].shift()).cumsum()
df.groupby(g, as_index = False).agg({
"Event": "first",
"Start": "first",
"End": "last"
})
Event Start End
0 A 1 2
1 B 3 4
2 A 5 8
3 B 9 12
4 A 13 14
</code></pre>