I currently have dataframe at the top. Is there a way to use a groupby function to get another dataframe to group the data and concatenate the words into the format like further below using python pandas?
Thanks
[
Advertisement
Answer
You can apply join
on your column after groupby
:
df.groupby('index')['words'].apply(','.join)
Example:
In [326]: df = pd.DataFrame({'id':['a','a','b','c','c'], 'words':['asd','rtr','s','rrtttt','dsfd']}) df Out[326]: id words 0 a asd 1 a rtr 2 b s 3 c rrtttt 4 c dsfd In [327]: df.groupby('id')['words'].apply(','.join) Out[327]: id a asd,rtr b s c rrtttt,dsfd Name: words, dtype: object