import pandas as pd
#构造数据
data=pd.DataFrame({'id':[1,1,2,2],'品牌':['A','B','C','D']})
#合并数据
data_new=data.groupby(['id'])['品牌'].apply(list).to_frame()
data_new['品牌']=data_new['品牌'].apply(lambda x:str(x).replace('[','').replace(']',''))
一列拆分多列
df_image = sql_image.groupby(['hotelCode'])['url'].apply(list).to_frame()
df_image['url'] = df_image['url'].apply(lambda x:','.join(x))
df_image.reset_index(inplace=True)