pandas 将多个DataFrame进行groupBy合并

import pandas as pd

df = pd.DataFrame({'uid': [1, 2, 3, 4],
                   'B': [1, 2, 3, 4],
                    'C': [4,5,6,7]})

df2=pd.DataFrame({'uid':[1,1,2,2],
                  'hello':['context','c2','c3','c4']
                  })
df2=df2.drop_duplicates()
df3=df2.groupby('uid')['hello'].agg(lambda x:' '.join(x))
df['bag_twts'] = df.uid.map(df3)

print(df)

输出：

 uid  B  C    bag_twts
0    1  1  4  context c2
1    2  2  5       c3 c4
2    3  3  6         NaN
3    4  4  7         NaN