python中把excel一些数据格式进行转换转换

 

 

data_dict = {'test01':[{'book1':'朝花夕拾'},{'book2':'红楼梦'}],
             'test02':[{'book1':'呐喊'},{'book2':'西游记'}]}
data_lsit = []
for key ,value in data_dict.items():
    b_dict = {}
    b_dict['name'] = key
    b_dict['books']=value
    data_lsit.append(b_dict)
print(data_lsit)