擅长:python、mysql、java
<p>我把台阶弄坏了:</p>
<pre><code>df['Group']=df.a.notnull().astype(int).cumsum()
df=df[df.a.isnull()]
df=df[df.Group.isin(df.Group.value_counts()[df.Group.value_counts()>3].index)]
df['count']=df.groupby('Group')['Group'].transform('size')
df.drop_duplicates(['Group'],keep='first')
Out[734]:
a Group count
ID
58238 NaN 2 6
</code></pre>