使用json和python将接收到的数据制表

import json

# 假设接收到的JSON数据
received_data = '''
{
  "students": [
    {
      "name": "Alice",
      "age": 20,
      "grade": "A"
    },
    {
      "name": "Bob",
      "age": 21,
      "grade": "B"
    },
    {
      "name": "Charlie",
      "age": 19,
      "grade": "C"
    }
  ]
}
'''

# 解析JSON数据
data = json.loads(received_data)

# 构建制表数据结构
table_data = []
table_data.append({"Name": "Age", "Grade": "Grade"})
for student in data["students"]:
    table_data.append({student["name"]: [student["age"], student["grade"]]})

# 制表输出
table = ""
for row in table_data:
    for key, value in row.items():
        table += f"{key:<10} | {value[0]:<4} | {value[1]:<6}\n"  # 根据需要设定对齐方式和列宽
    table += "-" * 30 + "\n"

print(table)

Name       | Age  | Grade 
--------------------------
Alice      | 20   | A     
Bob        | 21   | B     
Charlie    | 19   | C     
--------------------------