官网解析
pandas数据筛选 isin 和 ~ isin
import pandas as pd
data = {'city': ['Beijing', 'Shanghai', 'Guangzhou', 'Shenzhen', 'Hangzhou', 'Chongqing'],
'year': [2016, 2016, 2015, 2017, 2016, 2016],
'population': [2100, 2300, 1000, 700, 500, 500]}
frame = pd.DataFrame(data, columns=['year', 'city', 'population', 'debt'])
condition = ['Beijing', 'Shanghai']
print("———————————— isin ————————————")
print(frame.loc[frame['city'].isin(condition)])
print("———————————— ~ isin ————————————")
print(frame.loc[~frame['city'].isin(condition)])
>>>
———————————— isin ————————————
year city population debt
0 2016 Beijing 2100 NaN
1 2016 Shanghai 2300 NaN
———————————— not isin ————————————
year city population debt
2 2015 Guangzhou 1000 NaN
3 2017 Shenzhen 700 NaN
4 2016 Hangzhou 500 NaN
5 2016 Chongqing 500 NaN