擅长:python、mysql、java
<p><code>df</code>:</p>
<pre><code> id result
0 309209 Successful
1 309241 Successful
2 309241 Not Successful
3 309241 Not Successful
4 309241 Not Successful
</code></pre>
<p>使用<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.groupby.html" rel="nofollow noreferrer">^{<cd2>}</a>和<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.get_dummies.html" rel="nofollow noreferrer">^{<cd3>}</a></p>
<pre><code>df1 = df.join(pd.get_dummies(df.result,columns='result')).groupby('id').sum().reset_index()
df1['total'] = df1[df1.columns[1:]].sum(axis=1)
print(df1)
id Not Successful Successful total
0 309209 0 1 1
1 309241 3 1 4
</code></pre>