BUG: DataFrame.to_json ignores index if it is repeated in the DataFrame. · Issue #37600 · pandas-dev/pandas (original) (raw)

• [x ] I have checked that this issue has not already been reported.
  Similar to DataFrame.to_json silently ignores index parameter for most orients. #25513
• [x ] I have confirmed this bug exists on the latest version of pandas.
• (optional) I have confirmed this bug exists on the master branch of pandas.

Code Sample, a copy-pastable example

import pandas as pd

df=pd.DataFrame({'column':[0,1,2,3,4], 'probe':[0,1,2,2,3]})
df.set_index('probe',inplace=True)
out = df.to_json(orient='table', index=True)

assert 'primaryKey' in out

#### Problem description
DataFrame.to_json ignores index if it is repeated in the DataFrame.
Since pandas allows dataframes with repeated indexes, 
the function `to_json` should be able to write them.
If you want to limit this functionality, at least one warning should be implemented.

Note that 'to_pickle' works fine with repeated indexes, as expected.

#### Expected Output
Not Error in assert

#### Output of ``pd.show_versions()``

<details>

INSTALLED VERSIONS
------------------
commit           : 67a3d4241ab84419856b84fc3ebc9abcbe66c6b3
python           : 3.6.6.final.0
python-bits      : 64
OS               : Windows
OS-release       : 10
Version          : 10.0.19041
machine          : AMD64
processor        : Intel64 Family 6 Model 158 Stepping 9, GenuineIntel
byteorder        : little
LC_ALL           : None
LANG             : ES
LOCALE           : es_ES.cp1252

pandas           : 1.1.4
numpy            : 1.16.3
pytz             : 2018.5
dateutil         : 2.7.3
pip              : 20.2.3
setuptools       : 41.2.0
Cython           : None
pytest           : None
hypothesis       : None
sphinx           : None
blosc            : None
feather          : None
xlsxwriter       : None
lxml.etree       : 4.4.2
html5lib         : None
pymysql          : None
psycopg2         : None
jinja2           : 2.10.3
IPython          : 7.10.1
pandas_datareader: None
bs4              : 4.9.1
bottleneck       : None
fsspec           : None
fastparquet      : None
gcsfs            : None
matplotlib       : 2.2.3
numexpr          : None
odfpy            : None
openpyxl         : None
pandas_gbq       : None
pyarrow          : None
pytables         : None
pyxlsb           : None
s3fs             : None
scipy            : 1.2.1
sqlalchemy       : 1.3.18
tables           : None
tabulate         : None
xarray           : None
xlrd             : None
xlwt             : None
numba            : None

</details>