Skip to content

Comparison of (Multi)Index to tuple interprets tuple as collection #21517

Closed
@toobaz

Description

@toobaz

Code Sample, a copy-pastable example if possible

In [2]: mi = pd.MultiIndex.from_product([[1, 2]]*2)

In [3]: mi == mi[0]
Out[3]: False

In [4]: fl = pd.Index(range(4))

In [5]: fl == fl[0]
Out[5]: array([ True, False, False, False])

In [6]: fl == mi[0]
Out[6]: False

Problem description

The tuple should be interpreted as a key (value), and a boolean array should be returned (and this should probably be the correct behavior also for a flat index, i.e., In [6]:).

Expected Output

Out[5]:

Output of pd.show_versions()

INSTALLED VERSIONS

commit: None
python: 3.5.3.final.0
python-bits: 64
OS: Linux
OS-release: 4.9.0-6-amd64
machine: x86_64
processor:
byteorder: little
LC_ALL: None
LANG: it_IT.UTF-8
LOCALE: it_IT.UTF-8

pandas: 0.24.0.dev0+121.g6185722bb.dirty
pytest: 3.5.0
pip: 9.0.1
setuptools: 39.2.0
Cython: 0.25.2
numpy: 1.14.3
scipy: 0.19.0
pyarrow: None
xarray: None
IPython: 6.2.1
sphinx: 1.5.6
patsy: 0.5.0
dateutil: 2.7.3
pytz: 2018.4
blosc: None
bottleneck: 1.2.0dev
tables: 3.3.0
numexpr: 2.6.1
feather: 0.3.1
matplotlib: 2.2.2.post1153+gff6786446
openpyxl: 2.3.0
xlrd: 1.0.0
xlwt: 1.3.0
xlsxwriter: 0.9.6
lxml: 4.1.1
bs4: 4.5.3
html5lib: 0.999999999
sqlalchemy: 1.0.15
pymysql: None
psycopg2: None
jinja2: 2.10
s3fs: None
fastparquet: None
pandas_gbq: None
pandas_datareader: 0.2.1

Metadata

Metadata

Assignees

No one assigned

    Labels

    BugMultiIndexNested DataData where the values are collections (lists, sets, dicts, objects, etc.).Numeric OperationsArithmetic, Comparison, and Logical operations

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions