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.

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

ENH: to_json(index=False) #17394

Closed
Suor opened this Issue Aug 31, 2017 · 2 comments

Comments

Projects
None yet
3 participants
@Suor

Suor commented Aug 31, 2017

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 from Sometimes useless index data in DataFrame.to_json() to ENH: to_json(index=False) Aug 31, 2017

@jreback jreback added this to the Next Major Release milestone Aug 31, 2017

@jreback

This comment has been minimized.

Contributor

jreback commented Aug 31, 2017

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

@mpenkov

This comment has been minimized.

Contributor

mpenkov commented Sep 10, 2017

I've started looking into this.

reidy-p added a commit to reidy-p/pandas that referenced this issue Nov 29, 2017

reidy-p added a commit to reidy-p/pandas that referenced this issue Nov 30, 2017

@reidy-p reidy-p referenced this issue Dec 1, 2017

Merged

EHN: Add index parameter to to_json #18591

3 of 4 tasks complete

@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