Pandas将以DataFrame : ValueError:预期对象或值的形式打开JSON文件

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

Answer 2

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