how to remove a back slash from a JSON file

Question

I want to create a json file like this:

{"946705035":4,"946706692":4 ...}

I am taking a column that only contains Unix Timestamp and group them.

result = data['Last_Modified_Date_unixtimestamp_no_time'].value_counts()

In [21]: result.head()
Out[21]: 
1508284800    131
1508716800    106
1508371200    101
1508457600     99
1508630400     96
Name: Last_Modified_Date_unixtimestamp_no_time, dtype: int64

transform to a dict

result = result.to_dict()
result
'''
{1507161600: 1,
 1507852800: 1,
 1508198400: 64,
 1508284800: 131,
 ...
 1535155200: 1,
 1535241600: 1}
'''

import json
result = json.dumps(result)

with open('result.json', 'w') as fp:
    json.dump(result, fp, indent=4)

result this is the data structure that I expected

{"946705035":4,"946706692":4}

Possible duplicate of [Need to Pretty-Print JSON Data to a File using Python](https://stackoverflow.com/questions/9170288/need-to-pretty-print-json-data-to-a-file-using-python) — OneCricketeer, Aug 28 '18 at 04:45
Does this seem like a suitable solution? [Json dumps escaping forward slashes](https://stackoverflow.com/questions/27129681/json-dumps-escaping-forward-slashes) — Matthew, Aug 28 '18 at 04:45
I see you are working with pandas dataframe. In that case, if you want to send your df as a response, instead of converting it to json, consider converting it to dict and then encoding and sending dict to json. It works well. and that is the standard way to do it. Refer to my answer https://stackoverflow.com/a/73448710/4800690 — Aashish Chaubey, Aug 22 '22 at 17:04

iBug · Accepted Answer · 2018-08-28T04:39:24.790

19

You're dumping the JSON twice, which causes quotes to be escaped on the second dump. (After the first json.dumps the result is only a string, so you're just dumping a string instead of a dict again)

import json
# result = json.dumps(result)

with open('result.json', 'w') as fp:
    json.dump(result, fp, indent=4)

Or remove the second dump:

import json
result = json.dumps(result)

with open('result.json', 'w') as fp:
    # json.dump(result, fp, indent=4)
    print(result, file=fp)

edited Aug 28 '18 at 04:39

answered Aug 28 '18 at 04:33

iBug

35,554
7
89
134

Is there a simple test for `result`'s type? This way, one could write `if type(result) is : fp.write(result) ... else: json.dump(result,fp)` – blong May 01 '19 at 14:40
@blong `type(result) is str`, but better yet, keep track of your code and pay attention to *where* JSON is dumped. Only do it once, as stated in my answer. – iBug May 01 '19 at 14:59

score 1 · Answer 2 · answered Jul 31 '20 at 03:21

1

data_json=df.to_json(orient='records')
parsed=json.loads(data_json)

with open('my_data.json', 'w') as f:
    json.dump(parsed, f, indent=4)

answered Jul 31 '20 at 03:21

clemiblac

11
2

3

Please add some explanation about how this solves the question – Arghya Sadhu Jul 31 '20 at 04:15

score 0 · Answer 3 · answered Aug 22 '22 at 17:07

0

First convert the dataframe to dict

response = df.to_dict(orient="records")

And then encode the response to json

json_compatible_data = jsonable_encoder(response)

This should work well.

answered Aug 22 '22 at 17:07

Aashish Chaubey

589
1
8
22

score -1 · Answer 4 · answered Feb 18 '19 at 11:31

-1

The simplest way to solve the above problem is to play with json.dumps() and json.loads().

import json
result = json.dumps(result)

with open('result.json', 'w') as fp:
    json.loads(result, fp)

answered Feb 18 '19 at 11:31

Rushabh Sudame

414
1
6
22

Yes. You can try. – Rushabh Sudame Apr 02 '20 at 19:22
1

The second argument to [`json.loads()`](https://docs.python.org/3/library/json.html#json.loads) makes no sense - it accepts only one positional argument. – iBug Apr 03 '20 at 03:00

how to remove a back slash from a JSON file

4 Answers4

Linked