Pandas 将行组合成由斜杠分隔的字符串并由其他一些列聚合

Question

我有初始的DF，我想将“组合”列汇总成一个唯一的字符串，被斜线隔开，但尊重此类指示的顺序。 在所需的数据中，您可以找到我的最终目标数据集

raw_data = {'name': ['B','B','A','A','A','A','C'],
'date' : pd.to_datetime(pd.Series(['2017-04-03','2017-04-03','2017-03-31','2017-03-31','2017-03-31','2017-04-04','2017-04-04'])),
        'order': [2,1,4,2,1,1,1],
           'combo': ['x','y','x','y','z','x','x']}
df = pd.DataFrame(raw_data, columns = ['name','date','order','combo'])
df=df.sort_values(["name","date","order"])
df


desired_raw = {'name': ['A','A','B','C'],
'date' : pd.to_datetime(pd.Series(['2017-03-31','2017-04-04','2017-04-03','2017-04-04'])),
'combined_combo': ["z/y/x","x","y/x","x"]}

desired_data = pd.DataFrame(desired_raw, columns = ['name','date','combined_combo'])

desired_data

#what I did until now

df1 = df.groupby(['name','date'])['combo'].apply(list).reset_index(name='new')
df1

Answer 1

这是一种方法：

combined_combo = df.groupby(['name', 'date'])['combo'].agg('/'.join).rename('combined_combo')
print(combined_combo)

OUT：

name  date      
A     2017-03-31    z/y/x
      2017-04-04        x
B     2017-04-03      y/x
C     2017-04-04        x
Name: combined_combo, dtype: object

如果您不希望组作为索引使用：

desired_data = combined_combo.reset_index()