导入堆叠JSON fi

Question

我的问题与this one here相同，但没有回答，我希望将一个嵌套的JSON文件加载到python中。数据如下所示：

{"company_number":"09155805","data":        
{"etag":"4b7fa3c10d6022ccf76d5b4266365a1ed41bb6da","kind":"persons-with-    
significant-control-statement","links":{"self":"/company/09155805/persons- 
with-significant-control- 
statements/6EzwgguAevT_xs4JZq91pkUOvSw"},"notified_on":"2016-07- 
31","statement":"psc-details-not-confirmed"}}
{"company_number":"NI603905","data": 
{"etag":"f799cfaccc8642ff39b48031d59a5bc884c20b51","kind":"persons-with- 
significant-control-statement","links":{"self":"/company/NI603905/persons- 
with-significant-control- 
statements/OwgKYSF7ZCvrG7JCilW00zRsg3g"},"notified_on":"2016-07- 
28","statement":"no-individual-or-entity-with-signficant-control"}}
{"company_number":"05894872","data": 
{"etag":"2805e15088bb7117208b57aa490673801c3cde8c","kind":"persons-with- 
significant-control-statement","links":{"self":"/company/05894872/persons- 
with-significant-control-statements/CPKer2m8uYG5Vh4NLKTzsf- 
n10A"},"notified_on":"2016-08-03","statement":"no-individual-or-entity-with- 
signficant-control"}}

上一个问题的答案抛出了一个额外的数据错误。如何导入？你知道吗

Answer 1

您链接的问题包含有效的JSON，而您的JSON无效，因为它基本上如下所示：

{}
{}
{}

而一个有效的版本是这样的：

[
{},
{},
{}
]

如果您的JSON是行稀疏的，那么您将需要使用某种第三方库，比如https://jsonlines.readthedocs.io/en/latest/

或者，如果单个有效的JSON块在一行中，您可以逐行读取文件。你知道吗

另一种选择是确保JSON实际上是有效的。你知道吗