Spotify API:如何将不同层次的JSON信息提取到一个datFrame中

import pandas as pd
import json

# 假设获取到的JSON数据为json_data
json_data = '''
{
  "tracks": {
    "items": [
      {
        "id": "1",
        "name": "Song 1",
        "artists": [
          {
            "id": "101",
            "name": "Artist 1"
          },
          {
            "id": "102",
            "name": "Artist 2"
          }
        ]
      },
      {
        "id": "2",
        "name": "Song 2",
        "artists": [
          {
            "id": "201",
            "name": "Artist 3"
          },
          {
            "id": "202",
            "name": "Artist 4"
          }
        ]
      }
    ]
  }
}
'''

# 将JSON字符串转换为字典
data = json.loads(json_data)

# 递归函数，用于提取嵌套层次的信息
def extract_info(item, result):
    if isinstance(item, dict):
        for key, value in item.items():
            if isinstance(value, dict) or isinstance(value, list):
                extract_info(value, result)
            else:
                result[key] = value
    elif isinstance(item, list):
        for i in item:
            extract_info(i, result)

# 提取信息到DataFrame
result = {}
extract_info(data, result)
df = pd.DataFrame(result)

# 打印DataFrame
print(df)