擅长:python、mysql、java
<pre><code>Data = {'codes': ['123456', '789654789', '789654789', '54126', '123456'],
'names': ['google.com', 'reddit.com', 'bbc.com', 'google.com', 'google.com']
}
df = pd.DataFrame(Data, columns = ['codes','names'])
df=df.groupby(df.columns.tolist()).size().reset_index().rename(columns={0:'count'})
df['count']=df['count'].astype(str)+' '+df['names']
df = df.sort_values('names') .groupby('codes', sort=False)['count'].agg(lambda x: ','.join(x.astype(str))).reset_index()
print(df)
codes count
0 789654789 1 bbc.com,1 reddit.com
1 123456 2 google.com
2 54126 1 google.com
</code></pre>