Stack Overflow Asked by Franco Milanese on January 5, 2022
In [1]: import pandas as pd
...: a=pd.DataFrame([1,2,'a'])
In [2]: a.isin([1,'a'])
Out[2]:
0
0 True
1 False
2 True
In [3]: a.isin(pd.DataFrame([1,'a']))
Out[3]:
0
0 True
1 False
2 False
why isin cant find ‘a’ in a DataFrame but can in a list?.
PS: Using pandas 1.0.5
In [4]: pd.version
Out[4]: ‘1.0.5’
The pd.DataFrame.isin
docs spell out this behavior pretty clearly, emphasis my own.
If values is a DataFrame, then both the index and column labels must match.
So looking at your two DataFrames side by side:
a isin pd.DataFrame([1,'a'])
0 0
0 1 0 1 True <- 1 == 1 for col label (0) and index label (0)
1 2 1 a False <- 2 != 'a' for col label (0) and index label (1)
2 a False <- Nothing to align
Answered by ALollz on January 5, 2022
0 Asked on December 26, 2020 by james-lin
1 Asked on December 25, 2020 by vince
2 Asked on December 25, 2020 by nck_505
2 Asked on December 25, 2020 by outofworld
0 Asked on December 25, 2020 by rob-edlin
2 Asked on December 24, 2020 by frank-nocke
1 Asked on December 24, 2020 by nguyn-tng
0 Asked on December 24, 2020 by judson-abraham
1 Asked on December 24, 2020
active directory az azure azure active directory permissions
0 Asked on December 24, 2020 by thor_
1 Asked on December 23, 2020 by hillinharwich
3 Asked on December 23, 2020 by holly-wong
0 Asked on December 23, 2020 by aaron-waller
1 Asked on December 23, 2020 by diamondjoe12
2 Asked on December 23, 2020 by david-browning
Get help from others!
Recent Answers
Recent Questions
© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP