Dec-28-2021, 07:47 PM
Something like this.
import pandas as pd from io import StringIO data = StringIO("""\ _c0,_c4 0,b 0,g 0,f 1,a 1,f 1,c 2,f 2,e 2,a 2,c """) df = pd.read_csv(data, sep=",")
>>> df = df.groupby('_c0') >>> grouped_list = df["_c4"].apply(list) >>> grouped_list _c0 0 [b, g, f] 1 [a, f, c] 2 [f, e, a, c] Name: _c4, dtype: object >>> >>> df = grouped_list.reset_index() >>> df _c0 _c4 0 0 [b, g, f] 1 1 [a, f, c] 2 2 [f, e, a, c]