擅长:python、mysql、java
<p>将“ColToKeep”更改为字符串,然后使用代码</p>
<pre><code>In : df['ColToKeep'] = df['ColToKeep'].astype(str)
In : df.groupby(['User','ColToKeep'], as_index=False).sum()
Out:
User ColToKeep Col1ToSum Col2ToSum
0 AAA nan 60 20
1 ABA 2.24 180 100
2 ABC 1.015 40 650
3 BBB nan 10 15
4 XYZ 1.1 10 10
5 XYZ 1.5 10 10
</code></pre>
<p>如有必要,可以通过以下方式将COLTOTKEEP更改回浮动:</p>
<pre><code>df1 = df.groupby(['User','ColToKeep'], as_index=False).sum()
df1['ColToKeep'] = df1['ColToKeep'].astype(float)
print(df1)
User ColToKeep Col1ToSum Col2ToSum
0 AAA NaN 60 20
1 ABA 2.240 180 100
2 ABC 1.015 40 650
3 BBB NaN 10 15
4 XYZ 1.100 10 10
5 XYZ 1.500 10 10
</code></pre>