# 测试数据准备
df = pd.DataFrame({
'parent_article_id':['300001','300016','300015'],
'child_article_id':['100276','104040','104040'],
'parent_article_name': ['A','B','C']
})
df['NAME_NBR'] = df.groupby(['child_article_id']).cumcount()+1
df = df.pivot(index='child_article_id', columns='NAME_NBR', values=['parent_article_id','parent_article_name'])
df = df.sort_index(level=1, axis=1)
df.columns = ['parent{}'.format(c) for c in df.columns]
df.reset_index(inplace=True)
![](https://img-blog.csdnimg.cn/img_convert/5017c7dcacb3405e34000768ffca165d.png)