How to pic only duplicate values based on 2cols in pandas df?

Question

I have df like this:

df1:
    PL IN
    22 NE22
    22 NE22
    22 NE22
    33 DE33
    33 DE33
    66 NL66
    66 NL66
    66 NL66

I need to save csv with only unique value so the result should be:

    22 NE22
    33 DE33
    66 NL66

I know .unique() method but it works only on Series (?) I need to pic 2 col. Can someone give me an advice?

@RenéHöhle Thanks for the suggestion, but in that post is list hardcoding and only loops in core python. I hoped to answer as Erfan one. I didn't know that func. Thank U! — martin, Jun 28 '19 at 21:33

score 2 · Accepted Answer · answered Jun 28 '19 at 21:22

2

Drop the duplicates then write to csv.

df1 = df1.drop_duplicates(subset=['PL', 'IN'], keep='first')
df1.to_csv('my_unique_csv.csv', index=False)

answered Jun 28 '19 at 21:22

d_kennetz

1 Answers1