擅长:python、mysql、java
<pre><code>df.groupby(['fid',pd.Grouper(freq='D'),'condition']).size().groupby(level=[0,1]).head(1)
</code></pre>
<p>输出:</p>
<pre><code>fid condition
1 2017-08-02 Chance of a Thunderstorm 2
2 2017-08-02 Partly Cloudy 2
dtype: int64
</code></pre>