python读取json中多嵌套字典的键_python-将多嵌套的dict / json加载到熊猫中

我正在尝试将一个非常混乱的多嵌套JSON加载到熊猫中.我已经在使用json_normalize,但是试图弄清楚我如何加入2个similair嵌套字典,以及解压缩它们的子字典和列表,这一直困扰着我.我对大熊猫的了解有限,但我假设如果可以解决的话,我可以利用它的性能优势.

我有2个包含战争数据的字典,一个是从JSON API响应中加载的,另一个是在数据库中的.我正在尝试比较2个新的攻击和防御.

战争实例

{

"state": "active","team_size": 20,"teams": {

"id": "12345679","name": "Good Guys","level": 10,"attacks": 4,"destruction_percentage": 22.6,"members": [

{

"id": "1","name": "John","level": 12

},{

"id": "2","name": "Tom","level": 11,"attacks": [

{

"attackerTag": "2","defenderTag": "4","damage": 64,"order": 7

}

]

}

]

},"opponent": {