Pandas to_json not correctly formatting json file?

Question

I have a data frame I'm attempting to export to a json file. Currently my fame looks something like this

PRICE    FRUIT    COLOR
1        Apple    Red
2        Orange   Orange

When I use the following JSON call:

df.to_json(orient='records',lines=True)

I return

{'Price':1,'Fruit':Apple,'Color':Red}
{'Price':2,'Fruit':Orange,'Color':Orange}

when I want

[{'Price':1,'Fruit':Apple,'Color':Red}
{'Price':2,'Fruit':Orange,'Color':Orange}]

So that the JSON file doesn't read each item as the end of file.

shoalna · Accepted Answer · 2021-10-04 12:55:57Z

2

Just try

df.to_json(orient='records')

According to docs, if lines=True, pandas writes out line-delimited json format.

answered Oct 4, 2021 at 12:55

shoalna

584 bronze badges

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

1 Answer 1