擅长:python、mysql、java
<p>更新:命令序列会改变结果!这个序列对我有用:</p>
<pre><code>#Start with sorting the values
data_fr.sort_values(by='CA',ascending= True, inplace= True)
#Identify duplicates
data_fr['Unique Px']= ~data_fr.duplicated('CA')
#Group and aggregate in a new column
data_fr['$$'] = data_fr.groupby('CA')['$'].transform('sum')
</code></pre>