使用列表和字典解析嵌套的JSON，以将每个列表和字典的数据帧分开

import json

# 嵌套的JSON数据
json_data = '''
{
  "fruits": [
    {
      "name": "apple",
      "color": "red",
      "quantity": 10
    },
    {
      "name": "banana",
      "color": "yellow",
      "quantity": 5
    }
  ],
  "vegetables": [
    {
      "name": "carrot",
      "color": "orange",
      "quantity": 3
    },
    {
      "name": "spinach",
      "color": "green",
      "quantity": 7
    }
  ]
}
'''

# 将JSON数据解析为Python对象
data = json.loads(json_data)

# 使用列表解析提取每个水果的数据帧
fruits = [fruit for fruit in data['fruits']]

# 使用字典解析提取每个蔬菜的数据帧
vegetables = {vegetable['name']: vegetable for vegetable in data['vegetables']}

# 打印提取的数据帧
print("水果数据帧：")
for fruit in fruits:
    print(fruit)

print("蔬菜数据帧：")
for vegetable in vegetables.values():
    print(vegetable)

水果数据帧：
{'name': 'apple', 'color': 'red', 'quantity': 10}
{'name': 'banana', 'color': 'yellow', 'quantity': 5}
蔬菜数据帧：
{'name': 'carrot', 'color': 'orange', 'quantity': 3}
{'name': 'spinach', 'color': 'green', 'quantity': 7}