Remove duplicates in list in column in Pandas

Question

I have the dataframe like this

    Col1           Col2

['joe', 'joe']     ['joe']

['sam','bob']     ['sam'.'bob']

['mary','mary']   ['mary']

I want to use an apply function on Col1 to get my result in Col2. Meaning, I want my lists with the duplicates in Col1 to no longer have those duplicates in Col2. Tried various functions with an applying and set, no dice. Seems like it should be straightforward.

Answer 1

For get col two

df['ColB'] = df['Col1'].explode().groupby(level=0).unique()

 Want to be a Data Science expert? Come and join this Data Science Courses