如何从包含数组的嵌套json中获取扁平化数据帧

def flatten_json(json_data, prefix=''):
    result = {}
    for key, value in json_data.items():
        if isinstance(value, dict):
            nested = flatten_json(value, prefix + key + '_')
            result.update(nested)
        elif isinstance(value, list):
            for i, item in enumerate(value):
                if isinstance(item, dict):
                    nested = flatten_json(item, prefix + key + '_' + str(i) + '_')
                    result.update(nested)
                else:
                    result[prefix + key + '_' + str(i)] = item
        else:
            result[prefix + key] = value
    return result

import json

json_data = '''
{
  "name": "John",
  "age": 30,
  "languages": [
    {
      "name": "Python",
      "level": "advanced"
    },
    {
      "name": "JavaScript",
      "level": "intermediate"
    }
  ]
}
'''

data = json.loads(json_data)
flat_data = flatten_json(data)
print(flat_data)

{
  "name": "John",
  "age": 30,
  "languages_0_name": "Python",
  "languages_0_level": "advanced",
  "languages_1_name": "JavaScript",
  "languages_1_level": "intermediate"
}