python:分离出panda datafram中有重复项的行

2024-04-25 18:17:45 发布

您现在位置:Python中文网/ 问答频道 /正文

假设一个数据帧df有三列c1, c2, c3。在

df=pd.DataFrame()
df['c1']=[1,2,3,3,4]
df['c2']=["a1","a2","a2","a2","a1"]
df['c3']=[1,2,3,3,5]
print df
df1=df[df.duplicated()]
print df1

df1只有一行,即

^{pr2}$

但我想

    c1  c2  c3
2   3  a2   3
3   3  a2   3

如何得到它?还有一件事,如果我试图使用参数'keep'作为df1 = df[df.duplicated(keep=False)],它会给我错误

 Traceback (most recent call last):

 File "<ipython-input-572-188a22102b3e>", line 1, in <module>
 df1 = df[df.duplicated(keep=False)]

 File "C:\Users\Kanika\Anaconda\lib\site-packages\pandas\util\decorators.py", line 88, in wrapper
  return func(*args, **kwargs)

TypeError: duplicated() got an unexpected keyword argument 'keep'

Tags: 数据infalsea2dfa1linefile
2条回答
df1=df[df.duplicated(keep=False)]

此选项删除所有重复项,先显示“删除熊猫保留”。在

您为keep指定的值是多少。我想,在您的例子中,传递False作为keep值可能会解决这个问题。Pandas Duplicated Doc's 。希望有帮助。在

df1 = df[df.duplicated(keep=False)]

相关问题 更多 >