我已成功將簡(jiǎn)單的 JSON 轉(zhuǎn)換為 CSV。當(dāng)文件包含 JSON 對(duì)象數(shù)組時(shí)，我遇到了問(wèn)題。我使用的csv模塊不是pandas為了轉(zhuǎn)換。請(qǐng)參考以下處理成功和失敗的內(nèi)容：成功（當(dāng)文件包含單個(gè) json 對(duì)象列表/數(shù)組時(shí)）：[{"value":0.97,"key_1":"value1","key_2":"value2","key_3":"value3","key_11":"2019-01-01T00:05:00Z"}]失敗 ：[{"value":0.97,"key_1":"value1","key_2":"value2","key_3":"value3","key_11":"2019-01-01T00:05:00Z"}][{"value":0.97,"key_1":"value1","key_2":"value2","key_3":"value3","key_11":"2019-01-01T00:05:00Z"}][{"value":0.97,"key_1":"value1","key_2":"value2","key_3":"value3","key_11":"2019-01-01T00:05:00Z"}]該json.loads函數(shù)拋出異常如下：Extra data ; line 1 column 6789 (char 1234)如何處理此類(lèi)文件？編輯：使用 Kinesis Firehorse 刷新此文件并推送到 S3。我正在使用 lambda 下載文件并加載它并進(jìn)行轉(zhuǎn)換。所以它不是.json文件。
3 回答
夢(mèng)里花落0921
TA貢獻(xiàn)1772條經(jīng)驗(yàn) 獲得超6個(gè)贊
像這樣解析每一行：
with open('input.json') as f:
for line in f:
obj = json.loads(line)
慕姐4208626
TA貢獻(xiàn)1852條經(jīng)驗(yàn) 獲得超7個(gè)贊
因?yàn)槟奈募皇怯行У?JSON。您必須逐行讀取文件，然后將每一行單獨(dú)轉(zhuǎn)換為對(duì)象。
或者，您可以像這樣轉(zhuǎn)換文件結(jié)構(gòu)...
[
{
"value": 0.97,
"key_1": "value1",
"key_2": "value2",
"key_3": "value3",
"key_11": "2019-01-01T00:05:00Z"
},
{
"value": 0.97,
"key_1": "value1",
"key_2": "value2",
"key_3": "value3",
"key_11": "2019-01-01T00:05:00Z"
},
{
"value": 0.97,
"key_1": "value1",
"key_2": "value2",
"key_3": "value3",
"key_11": "2019-01-01T00:05:00Z"
}
]
它將是一個(gè)有效的 JSON 文件。
aluckdog
TA貢獻(xiàn)1847條經(jīng)驗(yàn) 獲得超7個(gè)贊
正如 tanaydin 所說(shuō)，您失敗的輸入不是有效的 json。它應(yīng)該是這樣的：
[
{
"value":0.97,
"key_1":"value1",
"key_2":"value2",
"key_3":"value3",
"key_11":"2019-01-01T00:05:00Z"
},
{"value":0.97,"key_1":"value1","key_2":"value2","key_3":"value3","key_11":"2019-01-01T00:05:00Z"},
{"value":0.97,"key_1":"value1","key_2":"value2","key_3":"value3","key_11":"2019-01-01T00:05:00Z"}
]
我假設(shè)您通過(guò)迭代對(duì)象列表并調(diào)用json.dumps每個(gè)對(duì)象來(lái)創(chuàng)建 json 輸出。您應(yīng)該創(chuàng)建字典列表，然后調(diào)用json.dumps整個(gè)列表。
list_of_dicts_to_jsonify = {}
object_attributes = ['value', 'key_1', 'key_2', 'key_3', 'key_11']
for item in list_of_objects:
# Convert object to dictionary
obj_dict = {}
for k in object_attributes:
obj_dict[k] = getattr(item, k) or None
list_of_dicts_to_jsonify.append(obj_dict)
json_output = json.dumps(list_of_dicts_to_jsonify)
添加回答
舉報(bào)
0/150
提交
取消