我想从mysql查询结果转换
DealerID | Dealer Name | SubDealerID | Subdealer Name
AL06 A L A S K A 0001 A L A S K A JKT
AL06 A L A S K A AG01 AGUS SANTOSO,BPK.
AL06 A L A S K A IM01 IMPERIAL, TOKO
AL09 ALFA ELECTRONIC 0001 ALFA ELECTRONIC
AL09 ALFA ELECTRONIC AN01 ANGGA MUHAMAD SOLEH
AL09 ALFA ELECTRONIC ER01 ERWIN KURNIAWAN
AL10 PT.ALFA 0001 PT.ALFA RETAILINDO TBK
AL10 PT.ALFA AL01 PT. ALFA RETAILINDO TBK
AL10 PT.ALFA AL02 PT.ALFA RETAILINDO TBK DPK
AL10 PT.ALFA AL03 PT.ALFA RETAILINDO TBK STR
AL10 PT.ALFA AL04 PT.ALFA RETAILINDO TBK
AL10 PT.ALFA AL05 PT.ALFA RETAILINDO TBK KBY
我需要使用python转换成这个json格式:
{
"data":
{
"dealerID": "AL06",
"dealer": "A L A S K A",
"sdealer" : [
{ "sdi": "AG01","sdealer": "AGUS SANTOSO,BPK."},
{ "sdi": "IM01","sdealer": "IMPERIAL, TOKO"}
]
}
}
有人能帮我吗,谢谢
也许我做得不好。但我已经尽力了,这是我的想法:
相关问题 更多 >
编程相关推荐