DataFrame.isin
DataFrame.isin(values)
检查DataFrame中的每个元素是否包含在值中。
Parameters
values | 如果values为Series,则索引必须匹配; 如果values为dict,则键必须匹配列名; 如果values为DataFrame,则索引和列标签必须匹配; |
---|---|
Example:value is list
import pandas as pd
df = pd.DataFrame({'site':['google', 'baidu'],
'age':[18, 39]})
df.isin([18, 22])
--------------------------------------------------------
site age
0 False True
1 False False
Example:value is dict
import pandas as pd
df = pd.DataFrame({'site':['google', 'baidu'],
'age':[18, 39]})
df.isin({'age': [18, 22]})
-----------------------------------------------------------
site age
0 False True
1 False False
Example:value is DataFrame
import pandas as pd
df = pd.DataFrame({'site':['google', 'baidu'],
'age':[18, 39]})
df.isin(pd.DataFrame({'site': ['pandas', 'wiki'],
'age': [18, 22]}))
-----------------------------------------------------
site age
0 False True
1 False False