python 对dataframe按照id分组然后以分号拼接后面的字符

 

import pandas as pd


df = {'id':['a','a','b','c','c'],
      'en':['apple','app','w','cf','as']}



df = pd.DataFrame(df)


grouped = df.groupby('id')

result = grouped['en'].unique()

result2 = result.reset_index()

result2['en2'] = result2['en'].apply(lambda x: ';'.join(x))