关于如何在一个列表中创建新的JSON文件并从JSON文件中删除最后一个逗号的字典数量

Question

我有大量的字典，所以我用这些字典创建了新的Json文件，但字典并没有添加到一个列表中，而创建新的Json文件时，它不会删除最后一个逗号

我在这里写我的数据看起来像，谁能建议更好的方法

感谢提前帮助将是感激!!

json_dict = {}
for li in jsonli:
json_dict.update(li)
with open(r"D:Userslaki.ayaDesktopInvalidemailstc.json", 'a+') as fout:
fout.write(json.dumps(json_dict, indent = 4,default=str))
fout.write(',n')
fout.close()

我得到的输出如下所示:

{
"email": "[e-mail]",
"properties": [
{
"property": "XlinkUserID",
"value": 5123456
},
{
"property": "register_time",
"value": "2022-12-01"
},
{
"property": "linked_alexa",
"value": 0
},
{
"property": "linked_googlehome",
"value": 0
},
{
"property": "n0x89_direct_connect_full_color_bulb__a19_",
"value": 1
}
]
},
{
"email": "[e-mail]",
"properties": [
{
"property": "XlinkUserID",
"value": 188882272
},
{
"property": "register_time",
"value": "2022-09-16"
},
{
"property": "linked_alexa",
"value": 1
},
{
"property": "linked_googlehome",
"value": 0
},
{
"property": "n0x89_direct_connect_full_color_bulb__a19_",
"value": 1
}
]
},
{
"email": "[e-mail]",
"properties": [
{
"property": "XlinkUserID",
"value": 100000708
},
{
"property": "register_time",
"value": "2022-11-30"
},
{
"property": "linked_alexa",
"value": 0
},
{
"property": "linked_googlehome",
"value": 0
},
{
"property": "n0x89_direct_connect_full_color_bulb__a19_",
"value": 1
}
]
},

我希望数据应该在一个列表中，并删除最后一个逗号

预计

[  
{
"email": "[e-mail]",
"properties": [
{
"property": "XlinkUserID",
"value": 5123456
},
{
"property": "register_time",
"value": "2022-12-01"
},
{
"property": "linked_alexa",
"value": 0
},
{
"property": "linked_googlehome",
"value": 0
},
{
"property": "n0x89_direct_connect_full_color_bulb__a19_",
"value": 1
}
]
},
{
"email": "[e-mail]",
"properties": [
{
"property": "XlinkUserID",
"value": 188882272
},
{
"property": "register_time",
"value": "2022-09-16"
},
{
"property": "linked_alexa",
"value": 1
},
{
"property": "linked_googlehome",
"value": 0
},
{
"property": "n0x89_direct_connect_full_color_bulb__a19_",
"value": 1
}
]
},
{
"email": "[e-mail]",
"properties": [
{
"property": "XlinkUserID",
"value": 100000708
},
{
"property": "register_time",
"value": "2022-11-30"
},
{
"property": "linked_alexa",
"value": 0
},
{
"property": "linked_googlehome",
"value": 0
},
{
"property": "n0x89_direct_connect_full_color_bulb__a19_",
"value": 1
}
]
}
]

请建议更好的方法

Answer 1

在文件open子句中使用json.dump-

import json
# some example data
json_data = [{'name':'Joe', 'age':40}, {'name':'Jane', 'age':50}]
with open('json_file_out.json', 'w') as fout:
json.dump(json_data, fout)