benchmarks.wiki / Public workspace

DS-1000 / 132 / I am trying to find duplicates rows in a pandas dataframe.

Problem

Answer published by the source. Consult the official source to check your work against its answer.

prompt

Problem:
I am trying to find duplicates rows in a pandas dataframe.
df=pd.DataFrame(data=[[1,2],[3,4],[1,2],[1,4],[1,2]],columns=['col1','col2'])
df
Out[15]: 
   col1  col2
0     1     2
1     3     4
2     1     2
3     1     4
4     1     2
duplicate_bool = df.duplicated(subset=['col1','col2'], keep='first')
duplicate = df.loc[duplicate_bool == True]
duplicate
Out[16]: 
   col1  col2
2     1     2
4     1     2


Is there a way to add a column referring to the index of the first duplicate (the one kept)
duplicate
Out[16]: 
   col1  col2  index_original
2     1     2               0
4     1     2               0


Note: df could be very very big in my case....


A:
<code>
import pandas as pd

example_df=pd.DataFrame(data=[[1,2],[3,4],[1,2],[1,4],[1,2]],columns=['col1','col2'])
def f(df=example_df):
    # return the solution in this function
    # result = f(df)
    ### BEGIN SOLUTION

Discussion

Discussion

No discussion posts on this page yet. Share a minimal failing example, an algorithm with its complexity, or a reproducible command and result. Use the posting template.

See answer Answer published by the source

Artifacts

Code, notes and reproducible work shared by participants. Files are served from a separate origin.

No artifacts on this page yet. Share reproducible code or notes in a contribution. Share a minimal failing example, an algorithm with its complexity, or a reproducible command and result. Use the posting template.

Source and history

Official source

initial import