我有一個 JSON 文件。我想更改為用戶所需的格式。input.json 文件[{ "Data": [{ "name": [" Devlopment", "34876", "Tez", "4578"], "results": [{ "sum": 54 }] }, { "name": ["production", "09876", "phonepay", "2312"], "results": [{ "sum": 50.0 }] }], "totalResult": { "results": [{ "sum": 2027.0 }] }, "unknownGroup": { "results": [{ "sum": 0.0 }] }, "performanceStats": { "fileReadCount": 1, "decompressionCount": 0, "decompressionCacheEnabledCount": 0 }, "metadata": { "eventTypes": ["Data_collection"], "eventType": "Data_collection", "openEnded": true } }, { "Data": [{ "name": [" Quality_Analyst", "623456", "slicepay", "989766"], "results": [{ "sum": 54 }] }, { "name": ["Testing", "7654", "krazybee", "1234"], "results": [{ "sum": 50.0 }] }], "totalResult": { "results": [{ "sum": 2027.0 }] }, "unknownGroup": { "results": [{ "sum": 0.0 }] }, "performanceStats": { "fileReadCount": 1, "decompressionCount": 0, "decompressionCacheEnabledCount": 0 }, "metadata": { "eventTypes": ["Data_collection"], "eventType": "Data_collection", "openEnded": true } }]I am expecting Output:==============================
2 回答
月關(guān)寶盒
TA貢獻(xiàn)1772條經(jīng)驗(yàn) 獲得超5個贊
嘗試一下：
json_data = ... # load your json file
for item in json_data:
new_data = []
for data in item["Data"]:
data_item = dict()
data_item["Domain_name"] = data["name"][0]
data_item["Domain_Id"] = data["name"][1]
data_item["app"] = data["name"][2]
data_item["appId"] = data["name"][3]
data_item["sum"] = data["results"][0]["sum"]
new_data.append(data_item)
item["Data"] = new_data
輸出：
[
{'Data': [
{'Domain_name': ' Devlopment',
'Domain_Id': '34876',
'app': 'Tez',
'appId': '4578',
'sum': 54},
{'Domain_name': 'production',
'Domain_Id': '09876',
'app': 'phonepay',
'appId': '2312',
'sum': 50.0}],
'totalResult': {'results': [{'sum': 2027.0}]},
'unknownGroup': {'results': [{'sum': 0.0}]},
'performanceStats':
{'fileReadCount': 1,
'decompressionCount': 0,
'decompressionCacheEnabledCount': 0},
'metadata':
{'eventTypes': ['Data_collection'],
'eventType': 'Data_collection',
'openEnded': True}},
{'Data': [
{'Domain_name': ' Quality_Analyst',
'Domain_Id': '623456',
'app': 'slicepay',
'appId': '989766',
'sum': 54},
...
狐的傳說
TA貢獻(xiàn)1804條經(jīng)驗(yàn) 獲得超3個贊
試試這個代碼：這里是 json_dic 你的 JSON-Data
def change_format(val_lst):
key_lst = ['Domain_name','Domain_Id','app','appId']
res_lst = []
for dic in val_lst:
temp_dic = {key_lst[i]:val for i,val in enumerate(dic['name'])}
temp_dic['sum'] = dic['results'][0]['sum']
res_lst.append(temp_dic)
return res_lst
print(list(map(lambda x:dict([(key,change_format(val_lst)) if key=='Data' else (key,val_lst) for key,val_lst in x.items()]),json_dic)))
結(jié)果：
[{'Data': [{'Domain_name': ' Devlopment', 'Domain_Id': '34876', 'app': 'Tez', 'appId': '4578', 'sum': 54}, {'Domain_name': 'production', 'Domain_Id': '09876', 'app': 'phonepay', 'appId': '2312', 'sum': 50.0}], 'totalResult': {'results': [{'sum': 2027.0}]}, 'unknownGroup': {'results': [{'sum': 0.0}]}, 'performanceStats': {'fileReadCount': 1, 'decompressionCount': 0, 'decompressionCacheEnabledCount': 0}, 'metadata': {'eventTypes': ['Data_collection'], 'eventType': 'Data_collection', 'openEnded': 'true'}}, {'Data': [{'Domain_name': ' Quality_Analyst', 'Domain_Id': '623456', 'app': 'slicepay', 'appId': '989766', 'sum': 54}, {'Domain_name': 'Testing', 'Domain_Id': '7654', 'app': 'krazybee', 'appId': '1234', 'sum': 50.0}], 'totalResult': {'results': [{'sum': 2027.0}]}, 'unknownGroup': {'results': [{'sum': 0.0}]}, 'performanceStats': {'fileReadCount': 1, 'decompressionCount': 0, 'decompressionCacheEnabledCount': 0}, 'metadata': {'eventTypes': ['Data_collection'], 'eventType': 'Data_collection', 'openEnded': 'true'}}]
使用我的函數(shù)來更改 new_json 數(shù)據(jù)的格式，我只是使用列表理解來更改 new_data.Happy Coding
添加回答
舉報
0/150
提交
取消