Remove duplicate values in each row of the column

Question

I have a Data Frame, which has a column that shows repeated values. It was the result of an inverse "explode" operation... trello_dataframe = trello_dataframe.groupby(['Card ID', 'ID List'], as_index=True).agg({'Member (Full Name)': lambda x: x.tolist()})

How do I remove duplicate values in each row of the column?

I attach more information: https://prnt.sc/RjGazPcMBX47

I would like to have the data frame like this: https://prnt.sc/y0VjKuewp872

Thanks in advance!

ArchAngelPwn · Accepted Answer · 2022-05-24 16:40:22Z

1

You will need to target the column and with a np.unique

import pandas as pd import numpy as np data = { 'Column1' : ['A', 'B', 'C'], 'Column2' : [[5, 0, 5, 0, 5], [5,0,5], [5]] } df = pd.DataFrame(data) df['Column2'] = df['Column2'].apply(lambda x : np.unique(x)) df

answered May 24, 2022 at 16:40

ArchAngelPwn

3,0461 gold badge6 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user16836078 Over a year ago

The column 2 looks familiar to me somewhere :D

Junior P Over a year ago

Hi, ArchAngelPwn, Great! It works perfectly! Thank you very much!

ArchAngelPwn Over a year ago

No problem, glad to help! If you liked the answer please make sure to hit the "answered" so others might be able to find the answer as well

Collectives™ on Stack Overflow

Remove duplicate values in each row of the column

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related