无法将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文件格式不符合预期。尝试解决它，它应该会起作用

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

Answer 2

您的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]}}