擅长:python、mysql、java
<p>创造性解决方案:</p>
<pre><code>In [49]: df.groupby('userid')['type'].sum().str.count('ab').reset_index()
Out[49]:
userid type
0 20 1
1 21 2
</code></pre>
<p>说明:</p>
<pre><code>In [50]: df.groupby('userid')['type'].sum()
Out[50]:
userid
20 aab
21 ababb
Name: type, dtype: object
</code></pre>