A列相同 B列合并

import pandas as pd
df = pd.read_csv('D:/pythondata/notebookpy/company_contact.csv',encoding='gbk')
df1=df.astype(str).groupby("ENTERPRISE_NAME").apply(lambda x: ';'.join(x.MOBILE_PHONE)).to_frame("MOBILE_PHONE").reset_index()
df2='D:/pythondata/notebookpy/concat_phone.csv' 
df1.to_csv(df2,index=False,encoding='gbk')

转换成