python pandas read dataframe and do not include index [duplicate]

Question

very simple question

I am reading an excel sheet with python and I want to print the results without the automatic index pandas adds

import pandas as pd

x=pd.read_excel(r'2_56_01.276295.xlsx',index_col=None)
print x[:3]

this prints the 1st 3 rows

   blahblah           Street Borough
0        55         W 192 ST   Bronx
1      2514  EAST TREMONT AV   Bronx
2       877     INTERVALE AV   Bronx

but I do not want the index

because I am creating a JSON array to display on a webpage and its just screwing it up — ziggy
– ziggy, Commented Aug 2, 2019 at 18:41
are you using df.to_json() if so i think you can use orient=r : pandas.pydata.org/pandas-docs/version/0.24.2/reference/api/… — anky
– anky, Commented Aug 2, 2019 at 18:43
@anky_91 did not know about this, looks super useful but the JSON is parsed in a unique way. but this may be of help — ziggy
– ziggy, Commented Aug 2, 2019 at 18:44

Alexander · Accepted Answer · 2019-08-02 18:42:32Z

1

print x.to_string(index=False)

should do the trick

answered Aug 2, 2019 at 18:42

Alexander

885 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1