python - 如何在 pandas 中将 B 列的唯一值分组并打印到 A 列？

Question

示例数据:

tz = ["us","eu","ca","de","us","eu","ca","us","eu"]
ip = ["2.3.3.1","2.3.3.1","2.3.3.1","2.3.3.1","2.3.3.1","5.3.3.1","2.3.3.1","4.3.3.1","2.3.3.1"]
val = ["2.3","2.3","2.3","2.3","2.3","2.3","2.3","2.3","2.3"]
r = pd.DataFrame({'tz':tz,'ip':ip,'val':val})
r
r.groupby(tz).describe()

我希望将结果打印为:

ca --> 2.3.3.1
de --> 2.3.3.1
eu --> 2.3.3.1, 5.3.3.1 
us --> 2.3.3.1, 4.3.3.1

Answer 1

独特作品:

>>> u = r.groupby(tz)['ip'].unique()
>>> for i in u.index:
        print(i, '-->', ', '.join(u[i]))

ca --> 2.3.3.1
de --> 2.3.3.1
eu --> 2.3.3.1, 5.3.3.1
us --> 2.3.3.1, 4.3.3.1