how to open json file using python

Question

JSONDecodeError: Expecting ':' delimiter: line 1 column 8388729 (char 8388728)

import json
with open('tweets.json') as jfile:
  d = json.load(jfile)

i tried using this code.but it did not work. this is the sample data enter image description here

Please provide enough code so others can better understand or reproduce the problem. — shamnad sherief, Jan 25 '23 at 06:56
try seeing the image i have provided i could not post the sample data. — Kishore Kumar, Jan 25 '23 at 07:01
An image is not useful, especially one with only about 10K characters when the failing offset is 8.3M+. Post text as *text*. At a minimum, examine the text at the offset of the error, such as `jfile.read()[8388710:8388750]` and look at what is wrong. — Mark Tolonen, Jan 25 '23 at 07:27
You need to look into the "upstream" system that's generating 'tweets.json'. — DarkKnight, Jan 25 '23 at 07:30
Please [edit] to show the pertinent data in the input file; it seems your JSON data contains a formatting error. See also https://meta.stackoverflow.com/questions/379403/problematic-questions-about-decoding-errors — tripleee, Jan 25 '23 at 07:52

score 0 · Accepted Answer · answered Jan 25 '23 at 07:06

The error shows that your json data is not valid. There must be some syntax error in the json data. Specifically, it seems that there is a problem with the delimiter (':') at the specified line and column number.

You can use any JSON validator to find out the issue. You can try this or this with a pretty formatter

how to open json file using python

1 Answers1