~/opt/anaconda3/lib/python3.9/json/_init_.py in loads(s, cls, object_hook, parse_float, parse_int, parse_constant, object_pairs_hook, **kw)ģ44 parse_int is None and parse_float is None andģ45 parse_constant is None and object_pairs_hook is None and not kw): ~/opt/anaconda3/lib/python3.9/json/_init_.py in load(fp, cls, object_hook, parse_float, parse_int, parse_constant, object_pairs_hook, **kw)Ģ91 kwarg otherwise ``JSONDecoder`` is used.Ģ95 parse_float=parse_float, parse_int=parse_int, JSONDecodeError Traceback (most recent call last)

#clicking on raw_nyc_phil.json under 'Input Files'ītctwit01 = json_normalize(d) #with open('./input/raw_nyc_phil.json') as f: JSONDecodeError: Extra data: line 2 column 1 (char 555297)įrom pandas.io.json import json_normalize #package for flattening json in pandas df When trying to run the Jupyter Notebook code, I received the following error: I’ve never seen the ‘l’ before, and haven’t found what it means. My understanding is that Twitter search API file data is nested JSON.

Nested json to csv python pandas