使用Pandas groupby连接多行中的字符串

Question

使用Pandas groupby连接多行中的字符串我想基于Pandas中的分组来合并数据帧中的几个字符串。到目前为止这是我的代码：import pandas as pdfrom io import StringIOdata = StringIO(""" "name1","hej","2014-11-01" "name1","du","2014-11-02" "name1","aj","2014-12-01" "name1","oj","2014-12-02" "name2","fin","2014-11-01" "name2","katt","2014-11-02" "name2","mycket","2014-12-01" "name2","lite","2014-12-01" """)# load string as stream into dataframedf = pd.read_csv(data,header=0, names=["name","text","date"],parse_dates=[2])# add column with monthdf["month"] = df["date"].apply(lambda x: x.month)我希望最终结果如下所示：我不知道如何使用groupby并在“text”列中应用某种字符串串联。任何帮助赞赏！

Answer 1

EdChum的答案为您提供了很大的灵活性，但如果您只想将字符串连接到列表对象列中，您还可以：

output_series = df.groupby(['name','month'])['text'].apply(list)