无法使用python访问json文件中的对象

Question

[
{
"label": "table",
"ocr_text": "table",
"score": 0,
"xmin": 4,
"xmax": 349,
"ymin": 20,
"ymax": 450,
"cells": [
{
"id": "bcb82571-1529-11ec-ac53-674c43174016",
"row": 1,
"col": 1,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 4,
"ymin": 20,
"xmax": 127,
"ymax": 56,
"score": 0.95537096,
"text": "CompanynName:",
"status": "",
"row_label": ""
},
{
"id": "bcb82572-1529-11ec-ac53-674c43174016",
"row": 1,
"col": 2,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 127,
"ymin": 20,
"xmax": 349,
"ymax": 56,
"score": 0.9363235,
"text": "Calibrus Inc. (CALB) - United States",
"status": "",
"row_label": ""
},
{
"id": "bcb82573-1529-11ec-ac53-674c43174016",
"row": 2,
"col": 1,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 4,
"ymin": 56,
"xmax": 127,
"ymax": 127,
"score": 0.9946152,
"text": "Company Profile:",
"status": "",
"row_label": ""
},
{
"id": "bcb82574-1529-11ec-ac53-674c43174016",
"row": 2,
"col": 2,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 127,
"ymin": 56,
"xmax": 349,
"ymax": 127,
"score": 0.97803277,
"text": "Calibrus, Inc. is a technology basednCo. It has two business units thatnleverage the technology capabilities.nThrough its Hosted Business Soluti",
"status": "",
"row_label": ""
},
{
"id": "bcb82575-1529-11ec-ac53-674c43174016",
"row": 3,
"col": 1,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 4,
"ymin": 127,
"xmax": 127,
"ymax": 144,
"score": 0.9714132,
"text": "Chairman:",
"status": "",
"row_label": ""
},
{
"id": "bcb82576-1529-11ec-ac53-674c43174016",
"row": 3,
"col": 2,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 127,
"ymin": 127,
"xmax": 349,
"ymax": 144,
"score": 0.9650206,
"text": "Common",
"status": "",
"row_label": ""
},
{
"id": "bcb82577-1529-11ec-ac53-674c43174016",
"row": 4,
"col": 1,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 4,
"ymin": 144,
"xmax": 127,
"ymax": 196,
"score": 0.9955621,
"text": "Mailing Address:",
"status": "",
"row_label": ""
},
{
"id": "bcb82578-1529-11ec-ac53-674c43174016",
"row": 4,
"col": 2,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 127,
"ymin": 144,
"xmax": 349,
"ymax": 197,
"score": 0.9852098,
"text": "Papago Spectrum, 1225 WestnWashington Street Suite 213, Tempe, AZn85281",
"status": "",
"row_label": ""
},
{
"id": "bcb82579-1529-11ec-ac53-674c43174016",
"row": 5,
"col": 1,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 4,
"ymin": 196,
"xmax": 127,
"ymax": 216,
"score": 0.9943174,
"text": "Website:",
"status": "",
"row_label": ""
},
{
"id": "bcb8257a-1529-11ec-ac53-674c43174016",
"row": 5,
"col": 2,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 127,
"ymin": 196,
"xmax": 349,
"ymax": 216,
"score": 0.9855827,
"text": "www.caiibrus.com",
"status": "",
"row_label": ""
},
{
"id": "bcb8257b-1529-11ec-ac53-674c43174016",
"row": 6,
"col": 1,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 4,
"ymin": 216,
"xmax": 127,
"ymax": 232,
"score": 0.985591,
"text": "Nation:",
"status": "",
"row_label": ""
},
{
"id": "bcb8257c-1529-11ec-ac53-674c43174016",
"row": 6,
"col": 2,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 127,
"ymin": 216,
"xmax": 349,
"ymax": 233,
"score": 0.9716967,
"text": "CHF",
"status": "",
"row_label": ""
},
{
"id": "bcb8257d-1529-11ec-ac53-674c43174016",
"row": 7,
"col": 1,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 4,
"ymin": 232,
"xmax": 127,
"ymax": 251,
"score": 0.99128944,
"text": "Classification:",
"status": "",
"row_label": ""
},
{
"id": "bcb8257e-1529-11ec-ac53-674c43174016",
"row": 7,
"col": 2,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 127,
"ymin": 232,
"xmax": 349,
"ymax": 251,
"score": 0.98732376,
"text": "Раper",
"status": "",
"row_label": ""
},
{
"id": "bcb8257f-1529-11ec-ac53-674c43174016",
"row": 8,
"col": 1,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 4,
"ymin": 251,
"xmax": 127,
"ymax": 269,
"score": 0.99421144,
"text": "Sub-Classification:",
"status": "",
"row_label": ""
},
{
"id": "bcb82580-1529-11ec-ac53-674c43174016",
"row": 8,
"col": 2,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 127,
"ymin": 251,
"xmax": 349,
"ymax": 269,
"score": 0.9886955,
"text": "Printing & Writing Paper",
"status": "",
"row_label": ""
},
{
"id": "bcb82581-1529-11ec-ac53-674c43174016",
"row": 9,
"col": 1,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 4,
"ymin": 269,
"xmax": 127,
"ymax": 287,
"score": 0.98516166,
"text": "Recorder:",
"status": "",
"row_label": ""
},
{
"id": "bcb82582-1529-11ec-ac53-674c43174016",
"row": 9,
"col": 2,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 127,
"ymin": 269,
"xmax": 349,
"ymax": 287,
"score": 0.98368365,
"text": "OTC",
"status": "",
"row_label": ""
},
{
"id": "bcb82583-1529-11ec-ac53-674c43174016",
"row": 10,
"col": 1,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 4,
"ymin": 287,
"xmax": 127,
"ymax": 305,
"score": 0.99582994,
"text": "PEG:",
"status": "",
"row_label": ""
},
{
"id": "bcb82584-1529-11ec-ac53-674c43174016",
"row": 10,
"col": 2,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 127,
"ymin": 287,
"xmax": 349,
"ymax": 305,
"score": 0.9912583,
"text": "CALB",
"status": "",
"row_label": ""
},
{
"id": "bcb82585-1529-11ec-ac53-674c43174016",
"row": 11,
"col": 1,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 4,
"ymin": 305,
"xmax": 127,
"ymax": 323,
"score": 0.9875233,
"text": "P. E. Ratio:",
"status": "",
"row_label": ""
},
{
"id": "bcb82586-1529-11ec-ac53-674c43174016",
"row": 11,
"col": 2,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 127,
"ymin": 305,
"xmax": 349,
"ymax": 323,
"score": 0.98438346,
"text": "4,245,144 (Year Ending Jan2010).",
"status": "",
"row_label": ""
},
{
"id": "bcb82587-1529-11ec-ac53-674c43174016",
"row": 12,
"col": 1,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 4,
"ymin": 322,
"xmax": 127,
"ymax": 341,
"score": 0.99576724,
"text": "Sedol:",
"status": "",
"row_label": ""
},
{
"id": "bcb82588-1529-11ec-ac53-674c43174016",
"row": 12,
"col": 2,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 127,
"ymin": 323,
"xmax": 349,
"ymax": 341,
"score": 0.9900464,
"text": "",
"status": "",
"row_label": ""
},
{
"id": "bcb82589-1529-11ec-ac53-674c43174016",
"row": 13,
"col": 1,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 4,
"ymin": 341,
"xmax": 127,
"ymax": 358,
"score": 0.9853235,
"text": "Currency Traded In:",
"status": "",
"row_label": ""
},
{
"id": "bcb8258a-1529-11ec-ac53-674c43174016",
"row": 13,
"col": 2,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 127,
"ymin": 341,
"xmax": 349,
"ymax": 359,
"score": 0.9750129,
"text": "ZAR",
"status": "",
"row_label": ""
},
{
"id": "bcb8258b-1529-11ec-ac53-674c43174016",
"row": 14,
"col": 1,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 4,
"ymin": 358,
"xmax": 127,
"ymax": 378,
"score": 0.99585706,
"text": "Listing Date:",
"status": "",
"row_label": ""
},
{
"id": "bcb8258c-1529-11ec-ac53-674c43174016",
"row": 14,
"col": 2,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 127,
"ymin": 358,
"xmax": 349,
"ymax": 378,
"score": 0.9904988,
"text": "23-05-2004",
"status": "",
"row_label": ""
},
{
"id": "bcb8258d-1529-11ec-ac53-674c43174016",
"row": 15,
"col": 1,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 4,
"ymin": 378,
"xmax": 127,
"ymax": 394,
"score": 0.9812952,
"text": "No. Of Employees:",
"status": "",
"row_label": ""
},
{
"id": "bcb8258e-1529-11ec-ac53-674c43174016",
"row": 15,
"col": 2,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 127,
"ymin": 378,
"xmax": 349,
"ymax": 394,
"score": 0.9752758,
"text": "130/EUA",
"status": "",
"row_label": ""
},
{
"id": "bcb8258f-1529-11ec-ac53-674c43174016",
"row": 16,
"col": 1,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 4,
"ymin": 394,
"xmax": 127,
"ymax": 414,
"score": 0.9942204,
"text": "Market Capital:",
"status": "",
"row_label": ""
},
{
"id": "bcb82590-1529-11ec-ac53-674c43174016",
"row": 16,
"col": 2,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 127,
"ymin": 394,
"xmax": 349,
"ymax": 414,
"score": 0.9909375,
"text": "|мс3,057,570",
"status": "",
"row_label": ""
},
{
"id": "bcb82591-1529-11ec-ac53-674c43174016",
"row": 17,
"col": 1,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 4,
"ymin": 414,
"xmax": 127,
"ymax": 431,
"score": 0.99172026,
"text": "Outstanding Shares:",
"status": "",
"row_label": ""
},
{
"id": "bcb82592-1529-11ec-ac53-674c43174016",
"row": 17,
"col": 2,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 127,
"ymin": 414,
"xmax": 349,
"ymax": 431,
"score": 0.98513913,
"text": "os6,794,600",
"status": "",
"row_label": ""
},
{
"id": "bcb82593-1529-11ec-ac53-674c43174016",
"row": 18,
"col": 1,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 4,
"ymin": 431,
"xmax": 127,
"ymax": 450,
"score": 0.96575403,
"text": "Issued Shares:",
"status": "",
"row_label": ""
},
{
"id": "bcb82594-1529-11ec-ac53-674c43174016",
"row": 18,
"col": 2,
"row_span": 1,
"col_span": 1,
"label": "",
"xmin": 127,
"ymin": 431,
"xmax": 349,
"ymax": 450,
"score": 0.96669304,
"text": "IS3,009,501",
"status": "",
"row_label": ""
}
],
"type": "table"
}
]

无法访问json文件中的数据。谁能告诉我如何访问数据那里我需要的内容在文本字段。我正在做一个数据输入工作，并希望将图像(表)中的数据转换为文本。使用纳米网我得到了这个json文件，但现在我无法访问json文件中的给定数据。谁能帮助解决这个问题，并告诉如何访问文本字段使用任何外键。

Answer 1

我建议像下面这样使用json python库。在data中，您需要第一个元素，因为您的数据在列表中。

import json
with open('test.json') as f:
data = json.load(f)
cells = data[0]['cells']
for cell in cells:
print(cell['text'])