将Json嵌套对象数组转换为表行

{
  "employees": [
    {
      "name": "John",
      "age": 30,
      "skills": ["JavaScript", "HTML", "CSS"]
    },
    {
      "name": "Jane",
      "age": 25,
      "skills": ["Python", "Java"]
    }
  ]
}

import json

# 解析Json数据
data = '''
{
  "employees": [
    {
      "name": "John",
      "age": 30,
      "skills": ["JavaScript", "HTML", "CSS"]
    },
    {
      "name": "Jane",
      "age": 25,
      "skills": ["Python", "Java"]
    }
  ]
}
'''
json_data = json.loads(data)

# 提取数据并创建表行
rows = []
for employee in json_data['employees']:
    row = {
        'name': employee['name'],
        'age': employee['age'],
        'skills': ', '.join(employee['skills'])
    }
    rows.append(row)

# 打印表行数据
for row in rows:
    print(row)

{'name': 'John', 'age': 30, 'skills': 'JavaScript, HTML, CSS'}
{'name': 'Jane', 'age': 25, 'skills': 'Python, Java'}