how to write dataframe in JSON in pretty print style?

Question

I want to convert my dataframe to json and dump it in a file in a pretty print format. I tried -

df.to_json(r'C:\users\madhur\Desktop\example.json,'orient = 'index')

the above code is dumping in json but in a single line.

I also tried

import json
hello = df.to_json(orient = 'index')
with open(r'C:\users\madhur\Desktop\example.json','a') as f:
    json.dump(hello,f,indent=4,sort_keys=True)

but the above code is giving a single line output the the output has a '\' before the double inverted commas.

the output looks like -

"{\"17668620_INCOLL\":{\"DRWECNTRY\":\"NEW ZEALAND........"

if some one has any suggestions, answers or need any more information regarding this query then please comment/answer.

Note - I'm using Python 3.6

Can you post some of your dataframe, some of your data, more of the JSON? — Evan, Nov 28 '18 at 16:38
Related? https://stackoverflow.com/questions/28976546/write-pandas-dataframe-to-line-delineated-json — Evan, Nov 28 '18 at 16:39

score 22 · Accepted Answer · edited Nov 13 '20 at 06:16

22

you can directly pass indent = int :

df.to_json(r'example.json', orient='index', indent=2 )

edited Nov 13 '20 at 06:16

Community

1
1

answered Apr 08 '20 at 13:11

Rahul Palyekar

244
3
4

score 3 · Answer 2 · answered Jun 15 '20 at 10:01

3

Use df.to_dict(orient='records') if you want to simply be able to copy paste something from REPL

answered Jun 15 '20 at 10:01

mathtick

6,487
13
56
101

how to write dataframe in JSON in pretty print style?

2 Answers2