Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

ENH: to_json(index=False) #17394

Closed
Suor opened this issue Aug 31, 2017 · 2 comments · Fixed by #18591
Closed

ENH: to_json(index=False) #17394

Suor opened this issue Aug 31, 2017 · 2 comments · Fixed by #18591
Labels
API Design Enhancement IO JSON read_json, to_json, json_normalize
Milestone
0.23.0

Comments

@Suor
Copy link

Suor commented Aug 31, 2017 •
edited
Loading

Code Sample, a copy-pastable example if possible

import pandas as pd

df = pd.DataFrame([[1,2,3],[4,5,6]], columns=['a','b','c'])
df.to_json(orient='split')
# '{"columns":["a","b","c"],"index":[0,1],"data":[[1,2,3],[4,5,6]]}'

Problem description

Useless index data increases dump size. Affects only orients 'split' and 'table'.

Expected Output

>>>  df.to_json(orient='split', index=False)
'{"columns":["a","b","c"],"data":[[1,2,3],[4,5,6]]}'

This resembles a bit how .to_csv(index=False) works.

Output of pd.show_versions()

INSTALLED VERSIONS ------------------ commit: None python: 2.7.13.final.0 python-bits: 64 OS: Linux OS-release: 4.10.0-28-generic machine: x86_64 processor: x86_64 byteorder: little LC_ALL: None LANG: en_US.UTF-8 LOCALE: en_US.UTF-8

pandas: 0.20.3
pytest: 2.6.4
pip: 9.0.1
setuptools: 36.2.5
Cython: None
numpy: 1.13.1
scipy: 0.16.0
xarray: None
IPython: 5.4.1
sphinx: None
patsy: 0.4.1
dateutil: 2.6.1
pytz: 2017.2
blosc: None
bottleneck: None
tables: None
numexpr: 2.6.2
feather: None
matplotlib: None
openpyxl: None
xlrd: None
xlwt: None
xlsxwriter: None
lxml: None
bs4: None
html5lib: None
sqlalchemy: None
pymysql: None
psycopg2: 2.6 (dt dec pq3 ext lo64)
jinja2: 2.7.3
s3fs: None
pandas_gbq: None
pandas_datareader: None
@jreback jreback changed the title Sometimes useless index data in DataFrame.to_json() ENH: to_json(index=False) Aug 31, 2017
@jreback jreback added this to the Next Major Release milestone Aug 31, 2017
@jreback
Copy link
Contributor

jreback commented Aug 31, 2017

this would be ok. a pull-request to implement would needed from the community for this.

@mpenkov
Copy link
Contributor

mpenkov commented Sep 10, 2017

I've started looking into this.

@jreback jreback mentioned this issue Sep 18, 2017
Closed
reidy-p added a commit to reidy-p/pandas that referenced this issue Nov 29, 2017
@reidy-p
EHN: Add index parameter to to_json (pandas-dev#17394)
11c90be
reidy-p added a commit to reidy-p/pandas that referenced this issue Nov 30, 2017
@reidy-p
EHN: Add index parameter to to_json (pandas-dev#17394)
03e8ec3
@reidy-p reidy-p mentioned this issue Dec 1, 2017
Merged
4 tasks
@jreback jreback modified the milestones: Next Major Release, 0.22.0 Dec 6, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
API Design Enhancement IO JSON read_json, to_json, json_normalize
Projects
None yet
Milestone
0.23.0
Development

Successfully merging a pull request may close this issue.

EHN: Add index parameter to to_json reidy-p/pandas
3 participants
@Suor @jreback @mpenkov