to_json() output format issue #14825
Labels
Duplicate Report
Duplicate issue or pull request
IO JSON
read_json, to_json, json_normalize
MultiIndex
https://github.com/hupili/pandas-to-json-multi-index-issue/blob/master/pandas%20to_json%20test.ipynb
Code Sample, a copy-pastable example if possible
Problem description
The exported JSON is ill-formatted
Expected Output
Output of
pd.show_versions()
pandas: 0.18.1
nose: 1.3.7
pip: 7.1.2
setuptools: 28.6.1
Cython: None
numpy: 1.11.2
scipy: 0.18.1
statsmodels: None
xarray: None
IPython: 5.1.0
sphinx: None
patsy: None
dateutil: 2.5.3
pytz: 2016.7
blosc: None
bottleneck: None
tables: None
numexpr: None
matplotlib: 1.4.3
openpyxl: None
xlrd: None
xlwt: None
xlsxwriter: None
lxml: None
bs4: 4.5.1
html5lib: None
httplib2: 0.9.2
apiclient: 1.5.4
sqlalchemy: 1.1.2
pymysql: None
psycopg2: 2.6.2 (dt dec pq3 ext lo64)
jinja2: 2.8
boto: 2.43.0
pandas_datareader: None
In [4]:
The text was updated successfully, but these errors were encountered: