擅长:python、mysql、java
<p>您不想在索引上分组。只要<code>'hotOut(pulse=1gal)'</code>发生更改,您就要分组</p>
<pre><code>s = df['hotOut(pulse=1gal)'].cumsum().shift().bfill()
(df.reset_index()
.groupby(s, as_index=False)
.agg({'Index': 'last', 'hotIn(gpm)': 'sum', 'hotOut(pulse=1gal)': 'last'})
.set_index('Index'))
</code></pre>
<hr/>
<pre><code> hotIn(gpm) hotOut(pulse=1gal)
Index
2019-03-23T00:00:05 24 1
2019-03-23T00:00:13 33 1
</code></pre>