{"kind":"task","effective_mode":"full","benchmark":{"kind":"benchmark","effective_mode":"full","slug":"ds-1000","formal_name":"DS-1000","introduction":"DS-1000 builds 1,000 data-science problems from real StackOverflow questions across seven libraries including NumPy, Pandas and Matplotlib. The problems are perturbed so that recalling the original answer does not solve them.","introduction_ja":"","introduction_en":"","category":"Category not supplied","task_count":null,"acquisition_status":"Acquisition status not supplied","official_url":"https://ds1000-code-gen.github.io/","indexing_mode":"noindex","profile":{"resources":[],"task_format":"","scoring":"","metric":"","size":"","answer_access":"","license":"","citation":"","maintainer":"","released":"","why_hard":"","related":[]}},"task_id":"edbf9372-dc5b-5f62-acc4-3b61c7915c38","task_key":"default--test--133","task_revision_id":"2","upstream_id":"133","short_description":"I am trying to find col duplicates rows in a pandas dataframe.","config":"default","split":"test","body":"{\"prompt\":\"Problem:\\nI am trying to find col duplicates rows in a pandas dataframe.\\ndf=pd.DataFrame(data=[[1,1,2,5],[1,3,4,1],[4,1,2,5],[5,1,4,9],[1,1,2,5]],columns=['val', 'col1','col2','3col'])\\ndf\\nOut[15]: \\n   val  col1  col2  3col\\n0    1     1     2     5\\n1    1     3     4     1\\n2    4     1     2     5\\n3    5     1     4     9\\n4    1     1     2     5\\nduplicate_bool = df.duplicated(subset=['col1','col2', '3col'], keep='first')\\nduplicate = df.loc[duplicate_bool == True]\\nduplicate\\nOut[16]: \\n   val  col1  col2  3col\\n2    1     1     2      5\\n4    1     1     2      5\\n\\n\\nIs there a way to add a column referring to the index of the first duplicate (the one kept)\\nduplicate\\nOut[16]: \\n   val  col1  col2 3col   index_original\\n2     4    1     2      5         0\\n4     1    1     2      5         0\\n\\n\\nNote: df could be very very big in my case....\\n\\n\\nA:\\n<code>\\nimport pandas as pd\\n\\n\\ndf=pd.DataFrame(data=[[1,1,2,5],[1,3,4,1],[4,1,2,5],[5,1,4,9],[1,1,2,5]],columns=['val', 'col1','col2','3col'])\\n</code>\\nresult = ... # put solution in this variable\\nBEGIN SOLUTION\\n<code>\\n\"}","display_format":"code","language":"","answer_status":"published","assets":[],"source_url":"https://ds1000-code-gen.github.io/","history":"initial import","indexing_mode":"noindex","subproblems":[],"grids":[]}