擅长:python、mysql、java
<p>如果数据帧已按<em>DateCompleted</em>列排序,那么您可能只需要<code>groupby.shift</code>:</p>
<pre><code>date = pd.to_datetime(df.DateCompleted).dt.date
df["NextTranSales"] = df.groupby(date).Sales.shift(-1)
</code></pre>
<p><a href="https://i.stack.imgur.com/vaIM3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vaIM3.png" alt="enter image description here"/></a></p>
<p>如果需要<code>LastRow</code>列,可以使用<code>groupby</code>找到最后一行索引,然后将<code>yes</code>分配给这些行:</p>
^{pr2}$
<p><a href="https://i.stack.imgur.com/KXhyn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KXhyn.png" alt="enter image description here"/></a></p>