標(biāo)題可能具有誤導(dǎo)性。我有一個(gè)要加載的 json 文件，如下所示：{"parent": [ {"venue": "SE", "city": "some name", "Rating": 2, "location": {"x": 100.0, "y": 1.0}, "pubMillis": 1581373546000} ], "startTime": "2020-02-12 00:00:00:000", "endTime": "2020-02-12 00:01:00:000"}{"parent": [ {"venue": "PP", "city": "some name 2", "Rating": 2, "location": {"x": 101.0, "y": 2.0}, "pubMillis": 1581373546000} ], "startTime": "2020-02-12 00:00:00:000", "endTime": "2020-02-12 00:05:00:000"}如圖所示，每個(gè)parent鍵都由分隔。\n我想讀這個(gè)，這是我的代碼：with open('filename.json', 'r') as content_file: content = content_file.read()records = json.loads(json.dumps(content))print(type(records)) #return as str如果我寫records = json.loads(content)，我會(huì)得到以下錯(cuò)誤：json.decoder.JSONDecodeError：額外數(shù)據(jù)：第 2 行第 1 列（字符 517）因此，json.loads(json.dumps(content))似乎工作。但是，我了解到轉(zhuǎn)換dumps->loads將返回 asstr而不是dict. 因此，我無法訪問諸如此類的項(xiàng)目，records["parents"]["location"]因?yàn)樗鼈兪亲址问降?。那么，如何通過轉(zhuǎn)換str為訪問內(nèi)部項(xiàng)目dict？
1 回答
30秒到達(dá)戰(zhàn)場
TA貢獻(xiàn)1828條經(jīng)驗(yàn) 獲得超6個(gè)贊
這是問題
看起來要么你有多個(gè)子文件，要么{.....}是一個(gè) json
要么
那些（{.....}）應(yīng)該在一個(gè)數(shù)組中......我已經(jīng)在數(shù)組方法下面展示了
a = '''{"parent": [
{"venue": "SE",
"city": "some name",
"Rating": 2,
"location": {"x": 100.0, "y": 1.0},
"pubMillis": 1581373546000}
],
"startTime": "2020-02-12 00:00:00:000",
"endTime": "2020-02-12 00:01:00:000"
}
{"parent": [
{"venue": "PP",
"city": "some name 2",
"Rating": 2,
"location": {"x": 101.0, "y": 2.0},
"pubMillis": 1581373546000}
],
"startTime": "2020-02-12 00:00:00:000",
"endTime": "2020-02-12 00:05:00:000"
}'''
a = [i.strip() if i.strip()!='}' else i.strip()+',' for i in a.split('\n') ]
a = '\n'.join(a)
a= '[\n'+a[:-1]+'\n]'
import json
a=json.loads(a)
print(a)
[{'endTime': '2020-02-12 00:01:00:000',
'parent': [{'Rating': 2,
'city': 'some name',
'location': {'x': 100.0, 'y': 1.0},
'pubMillis': 1581373546000,
'venue': 'SE'}],
'startTime': '2020-02-12 00:00:00:000'},
{'endTime': '2020-02-12 00:05:00:000',
'parent': [{'Rating': 2,
'city': 'some name 2',
'location': {'x': 101.0, 'y': 2.0},
'pubMillis': 1581373546000,
'venue': 'PP'}],
'startTime': '2020-02-12 00:00:00:000'}]
這就是您獲取數(shù)據(jù)的方式
a=json.loads(a)
#print(a)
print(a[0]['parent'][0]['location'])
{'x': 100.0, 'y': 1.0}
如果你想將文件讀入內(nèi)存
a = "".join([i for i in open('yourFileLocation','r').readlines()])
現(xiàn)在你a在內(nèi)存中有一個(gè)多行字符串
添加回答
舉報(bào)
0/150
提交
取消