擅长:python、mysql、java
<p>在熊猫中,您可以使用<code>idxmax</code>获得每组的最大值指标:</p>
<pre><code>In [17]: df.loc[df.groupby(['LastName','FirstName','MiddleInit','Company'])['LogDate'].idxmax(), :]
Out[17]:
LastName FirstName MiddleInit Company Team LogDate
6 brady thomas c compB teama 2015-10-02 03:15:00
4 lamb mary b compA teamb 2015-10-04 01:15:00
10 smith john d compB teamb 2015-10-05 09:15:00
2 smith joseph a compA teamc 2015-10-01 02:15:00
</code></pre>