字典（键值为不等长字典）、列表嵌套字典转为DataFrame类型，DataFrame类型转为json格式数据

待转换数据

classification = {
    "1":["1","2","3","4","5","6","7","8","9","10","11"],
    "2":["16","17","18"],
    "3":["22","23","24","25","26","27A"],
    "4":["28","29","30","31","32"],
    "5":["35","36","37","38","39","40","41","42","44","45","46"],
    "6":["50","51","52","54","55","56","57","58","59","60"],
}
class_label = [
    {"1":"学生个人基础信息"},
    {"2":"学生个人辅助信息"},
    {"3":"学生学籍基本信息"},
    {"4":"学生个人联系信息"},
    {"5":"学生个人扩展信息"},
    {"6":"学生家庭成员或监护人信息一"},
]

程序代码

程序主要借助zip函数与列表表达式转换，将给定转换为json需转经DataFrame格式，orient='records',force_ascii=False

import pandas as pd
a= [list(class_label[i].values())[0] for i in range(len(class_label))]

for key ,value in classification.items():
   print(key,value)

b= [list(value) for value in classification.values()]
c = [list(key)[0] for key in classification.keys()]
d = zip(a,b,c)
e = pd.DataFrame(list(zip(c,a,b)),columns=['idx','name','value'])
ee=e.to_json(orient='records',force_ascii=False)

print('a:%s'%a)
print('b:%s'%b)
print('c:%s'%c)
print('d:%s'%d)
print('e:%s'%e)
print('ee:%s'%ee)

运行结果：

1 ['1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11']
2 ['16', '17', '18']
3 ['22', '23', '24', '25', '26', '27A']
4 ['28', '29', '30', '31', '32']
5 ['35', '36', '37', '38', '39', '40', '41', '42', '44', '45', '46']
6 ['50', '51', '52', '54', '55', '56', '57', '58', '59', '60']

a:['学生个人基础信息', '学生个人辅助信息', '学生学籍基本信息', '学生个人联系信息', '学生个人扩展信息', '学生家庭成员或监护人信息一']

b:[['1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11'], ['16', '17', '18'], ['22', '23', '24', '25', '26', '27A'], ['28', '29', '30', '31', '32'], ['35', '36', '37', '38', '39', '40', '41', '42', '44', '45', '46'], ['50', '51', '52', '54', '55', '56', '57', '58', '59', '60']]

c:['1', '2', '3', '4', '5', '6']

d:<zip object at 0x0000020A7DDDB3C8>

e:  idx           name                                         value
0   1       学生个人基础信息           [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11]
1   2       学生个人辅助信息                                  [16, 17, 18]
2   3       学生学籍基本信息                     [22, 23, 24, 25, 26, 27A]
3   4       学生个人联系信息                          [28, 29, 30, 31, 32]
4   5       学生个人扩展信息  [35, 36, 37, 38, 39, 40, 41, 42, 44, 45, 46]
5   6  学生家庭成员或监护人信息一      [50, 51, 52, 54, 55, 56, 57, 58, 59, 60]

ee:[{"idx":"1","name":"学生个人基础信息","value":["1","2","3","4","5","6","7","8","9","10","11"]},{"idx":"2","name":"学生个人辅助信息","value":["16","17","18"]},{"idx":"3","name":"学生学籍基本信息","value":["22","23","24","25","26","27A"]},{"idx":"4","name":"学生个人联系信息","value":["28","29","30","31","32"]},{"idx":"5","name":"学生个人扩展信息","value":["35","36","37","38","39","40","41","42","44","45","46"]},{"idx":"6","name":"学生家庭成员或监护人信息一","value":["50","51","52","54","55","56","57","58","59","60"]}]