python 判断两列有重复数据_Pandas统计重复的列里面的值方法

pandas

代码如下:

import pandas as pd

import numpy as np

salaries = pd.DataFrame({

'name': ['BOSS', 'Lilei', 'Lilei', 'Han', 'BOSS', 'BOSS', 'Han', 'BOSS'],

'Year': [2016, 2016, 2016, 2016, 2017, 2017, 2017, 2017],

'Salary': [1, 2, 3, 4, 5, 6, 7, 8],

'Bonus': [2, 2, 2, 2, 3, 4, 5, 6]

})

print(salaries)

print(salaries['Bonus'].duplicated(keep='first'))

print(salaries[salaries['Bonus'].duplicated(keep='first')].index)

print(salaries[salaries['Bonus'].duplicated(keep='first')])

print(salaries['Bonus'].duplicated(keep='last'))

print(salaries[salaries['Bonus'].duplicated(keep='last')].index)

print(salaries[salaries['Bonus'].duplicated(keep='last')])

输出如下：

Bonus Salary Year name

0 2 1 2016 BOSS

1 2 2 2016 Lilei

2 2 3 2016 Lilei

3 2 4 2016 Han

4 3 5 2017 BOSS

5 4 6