Code Sample, a copy-pastable example if possible
t = [1, 2, 3, 4, 5]
tt = [2, 3, 4, 5, 7]
d1 = DataFrame(t, columns=['a'], index=t)
d2 = DataFrame(tt, columns=['b'])
r = pd.merge(d1, d2, how='left', left_index=True, right_on='b', copy=False)
print(r) pd.show_versions()
Expected Output
/usr/local/Cellar/python3/3.5.0/Frameworks/Python.framework/Versions/3.5/bin/python3.5 /var/root/finalworkspace/python/daas/core/process_data.py a b 4 1 1.0 0 2 2.0 1 3 3.0 2 4 4.0 3 5 5.0
output of pd.show_versions()
INSTALLED VERSIONS
commit: None python: 3.5.0.final.0 python-bits: 64 OS: Darwin OS-release: 14.5.0 machine: x86_64 processor: i386 byteorder: little LC_ALL: None LANG: None
pandas: 0.18.1 nose: None pip: 8.1.2 setuptools: 25.1.4 Cython: None numpy: 1.11.1 scipy: None statsmodels: None xarray: None IPython: None sphinx: None patsy: None dateutil: 2.5.3 pytz: 2016.6.1 blosc: None bottleneck: None tables: None numexpr: None matplotlib: 1.5.1 openpyxl: None xlrd: None xlwt: None xlsxwriter: None lxml: None bs4: None html5lib: None httplib2: None apiclient: None sqlalchemy: None pymysql: 0.6.7.None psycopg2: None jinja2: 2.8 boto: None pandas_datareader: None
Process finished with exit code 0
Comment From: Dr-Irv
This is related to the discussion in #13371.
Comment From: mroeschke
Since https://github.com/pandas-dev/pandas/issues/13371 is further along in the discussion, closing in favor of that issue