Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Duplicate information
#6
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]
jcorreaa likes this post
Reply


Messages In This Thread
Duplicate information - by jcorreaa - Dec-27-2021, 11:53 PM
RE: Duplicate information - by Larz60+ - Dec-28-2021, 02:11 AM
RE: Duplicate information - by jcorreaa - Dec-28-2021, 02:38 AM
RE: Duplicate information - by Larz60+ - Dec-28-2021, 11:04 AM
RE: Duplicate information - by jcorreaa - Dec-28-2021, 05:49 PM
RE: Duplicate information - by snippsat - Dec-28-2021, 07:47 PM
RE: Duplicate information - by jcorreaa - Dec-28-2021, 11:34 PM
RE: Duplicate information - by BashBedlam - Dec-28-2021, 10:38 PM

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020