python - ValueError when using pandas.read_json -


i made 250mb json file should this:

[ {"a":"uniquevalue0", "b":[1,2,3]},    {"a":"uniquevalue1", "b":[1]},    {"a":"uniquevalue2", "b":[1,2,3,4]} ] 

where "b" value can variable len >= 1. this says have valid json.

i call

df = pandas.read_json('ut1.json', orient = 'records', dtype={"a":str, "b":list}) 

here documentation. when reading pandas dataframe, following traceback:

traceback (most recent call last):   file "<stdin>", line 1, in <module>   file "/.../pandas/io/json.py", line 198, in read_json          date_unit).parse()   file "/.../pandas/io/json.py", line 266, in parse      self._parse_no_numpy()   file "/.../pandas/io/json.py", line 496, in _parse_no_numpy     loads(json, precise_float=self.precise_float), dtype=none) valueerror: unexpected character found when decoding 'true' 

can't think of going wrong. the python file throwing error not helpful.

i had same error message, , solved using absolute path.

import os basepath = os.path.dirname(os.path.abspath(__file__)) df = pandas.read_json(basepath + '/ut1.json', orient = 'records', dtype={"a":str, "b":list}) 

that worked me!


Comments

Popular posts from this blog

ruby on rails - RuntimeError: Circular dependency detected while autoloading constant - ActiveAdmin.register Role -

c++ - OpenMP unpredictable overhead -

javascript - Wordpress slider, not displayed 100% width -