我认为您需要groupby
汇总tuple
,然后转换为list
:
df = df.groupby(['id','name']).agg(lambda x: tuple(x)).applymap(list).reset_index()
print (df)
id name \
0 2 birth_france_by_region
1 3 long_lat
2 4 random_time_series
3 5 birth_names
URL Type
0 [http://abc.cm, http://pt.python] [T1, T2]
1 [http://abc.cm, http://pqur.com] [T3, T1]
2 [http://sadsdc.com, http://sadcadf.com] [T2, T3]
3 [http://google.;com, http://helloworld.com, ht... [T1, T2, T3]
因为在0.20.3版本中引发错误:
df = df.groupby(['id','name']).agg(lambda x: x.tolist())
ValueError:函数不会减少