擅长:python、mysql、java
<p>IIUC然后就可以调用groupby对象上的<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.core.groupby.GroupBy.first.html#pandas.core.groupby.GroupBy.first" rel="nofollow">^{<cd1>}</a>:</p>
<pre><code>In [191]:
df.groupby(['Period','Company']).first()
Out[191]:
Estimate Value AnnounceDate
Period Company
2013-12-31 Z Estimate5: 0,21 2015-09-30
2014-12-31 Y Estimate3: 0,26 2015-07-05
2015-12-31 X Estimate1: 0,24 2015-01-01
</code></pre>
<p>如果要对结果进行排序,请在<code>groupby</code>之前对df进行排序:</p>
<pre><code>In [194]:
df.sort(columns='AnnounceDate').groupby(['Period','Company']).first()
Out[194]:
Estimate Value AnnounceDate
Period Company
2013-12-31 Z Estimate5: 0,21 2015-09-30
2014-12-31 Y Estimate3: 0,26 2015-07-05
2015-12-31 X Estimate1: 0,24 2015-01-01
</code></pre>