将嵌套 JSON 中的逗号分隔字符串转换为列表 Python

Question

我的 JSON 数据如下所示：   [{        "coverageResponse": "100000\/500000\/1000000",        "insuranceLine": "COMMERCIAL",        "coverageCategory": "COVERAGE",        "carriers": [{            "carrierId": "LMICO",            "states": "GA, CA",            "excludedStates": "PA, NY"        }, {            "carrierId": "CNICO",            "states": "NY, PA",            "excludedStates": "CA, MI, OH"        }]    },    {        "coverageResponse": "222\/333\/111",        "insuranceLine": "COMMERCIAL",        "coverageCategory": "COVERAGE",        "carriers": [{            "carrierId": "LMICO",            "states": "GA, CA",            "excludedStates": "PA, NY"        }, {            "carrierId": "CNICO",            "states": "NY, PA",            "excludedStates": "CA, MI, OH"        }]    }]我希望states里面excludedStates的内容carriers出现在列表中这是我的输出期望： [{        "coverageResponse": "100000\/500000\/1000000",        "insuranceLine": "COMMERCIAL",        "coverageCategory": "COVERAGE",        "carriers": [{            "carrierId": "LMICO",            "states": ["GA, CA"],            "excludedStates": ["PA, NY"]        }, {            "carrierId": "CNICO",            "states": ["NY, PA"],            "excludedStates": ["CA, MI, OH"]        }]    },   {    "coverageResponse": "222\/333\/111",    "insuranceLine": "COMMERCIAL",    "coverageCategory": "COVERAGE",    "carriers": [{        "carrierId": "LMICO",        "states": "GA, CA",        "excludedStates": "PA, NY"    }, {        "carrierId": "CNICO",        "states": "NY, PA",        "excludedStates": "CA, MI, OH"    }]}]

Answer 1

您的问题的解决方案：

init_json = #your json

for i, external in enumerate(init_json):

   for j, internal in enumerate(external['carriers']): 

      init_json[i]['carriers'][j]['states'] = internal['states'].split(', ')

      init_json[i]['carriers'][j]['excludedStates'] = internal['excludedStates'].split(', ')