python读取嵌套json_将嵌套Json读入Pandas

--------------------------------------------------------------------------- KeyError Traceback (most recent call

last) in ()

----> 1 works_data = json_normalize(data=data['results'], record_path='traits')

2 works_data.head()

C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\json\normalize.py

in json_normalize(data, record_path, meta, meta_prefix, record_prefix,

errors, sep)

257 records.extend(recs)

258

--> 259 _recursive_extract(data, record_path, {}, level=0)

260

261 result = DataFrame(records)

C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\json\normalize.py

in _recursive_extract(data, path, seen_meta, level)

233 else:

234 for obj in data:

--> 235 recs = _pull_field(obj, path[0])

236

237 # For repeating the metadata later

C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\json\normalize.py

in _pull_field(js, spec)

180 result = result[field]

181 else:

--> 182 result = result[spec]

183

184 return result

KeyError: 'traits'