无法将JSON文件作为DataFrame:ValueError:预期的对象或值打开

Question

我的JSON文件看起来像

{"Article":{"161":"Iran jails blogger for 14 years\n\nAn ........"},"Preprocessed-Article":{"161":"Iran jails blogger 14.........."},"Vector":{"161":[0.0,0.0,0.0,0.0,0.0......]}}

我正在尝试使用

df = pd.read_json(r'/content/NewsArticles.json',lines = False)
print(df.head())

读取文件。但是我越来越

/usr/local/lib/python3.6/dist-packages/pandas/io/json/_json.py in _parse_no_numpy(self)
   1117         if orient == "columns":
   1118             self.obj = DataFrame(
-> 1119                 loads(json, precise_float=self.precise_float), dtype=None
   1120             )
   1121         elif orient == "split":

ValueError: Expected object or value

请帮忙

Answer 1

您的JSON文件可能已损坏。如果我通过完成字符串周围的引号并去掉省略号来修改您的JSON示例，那么您的代码运行良好：

{"Article":{"161":"Iran jails blogger for 14 years\n\nAn ........"},
"Preprocessed-Article":{"161":"Iran jails blogger 14.........."},
"Vector":{"161":[0.0,0.0,0.0,0.0,0.0]}}