擅长:python、mysql、java
<p>您可以使用<a href="http://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.core.groupby.GroupBy.agg.html" rel="nofollow noreferrer">^{<cd1>}</a>by dictionary-所有列仅通过<code>Comment</code>by <code>join</code>聚合:</p>
<pre><code>df = pd.DataFrame({
'Comment':list('abcdef'),
'B':[4,5,4,5,5,4],
'C':[7,8,9,4,2,3],
'D':[1,3,5,7,1,0],
'E':[5,3,6,9,2,4],
'source':list('aaabbc')
})
d = dict.fromkeys(df.columns.difference(['source']), 'first')
d['Comment'] = ', '.join
merge_df = df.groupby('source', as_index=False).agg(d)
print (merge_df)
source B C Comment D E
0 a 4 7 a, b, c 1 5
1 b 5 4 d, e 7 9
2 c 4 3 f 0 4
</code></pre>