How can I combine the texts with same date in the python dataframe?

user_12005300 0
Viewed 163

I have the following data frame and I want to gather texts with the same date on a single date.

date        text
2020-09-10  text1
2020-09-10  text2
2020-09-09  text3
2020-09-09  text4
2020-09-08  text5
2020-09-08  text6

My expected data frame is like that.

date        text
2020-09-10  text1text2
2020-09-09  text3text4
2020-09-08  text5text6
pandas multiple-columns dataframe concatenation python
2 Answers

This should do the trick.

import numpy as np
import pandas as pd

df = pd.DataFrame({'date': ['2020-09-10','2020-09-10','2020-09-09','2020-09- 
09','2020-09-08','2020-09-08'],'text':['134','13','2','3','4','5']})
df.groupby('date')['text'].sum()
user_105458170

df.groupby('date').agg({'text':'sum'})

date        text
2020-09-10  text1text2
2020-09-09  text3text4
2020-09-08  text5text6
user_60319950
Related