将带有上下级children关系的json转为有上下级的表

一、json数据

data = {'name': 'b1',
 'id': 1,
 'p_id': 0,
 'children': [{'name': 'b2',
   'id': 2,
   'p_id': 1,
   'children': [{'name': 'b4',
     'id': 4,
     'p_id': 2,
     'children': [{'name': 'b6', 'id': 6, 'p_id': 4}]}]},
  {'name': 'b3',
   'id': 3,
   'p_id': 1,
   'children': [{'name': 'b5', 'id': 5, 'p_id': 3}]}]}

二、转换程序

out=[]
o_1={}
for k_1,v_1 in data.items():
    if k_1 != 'children':
        o_1[k_1]=v_1
    elif k_1== 'children': 

        for c_2 in v_1:
            o_2={}
            for k_2,v_2 in c_2.items():
                if k_2 != 'children':
                    o_2[k_2]=v_2
                    print(o_2)
                elif k_2 == 'children':

                    for c_3 in v_2:
                        o_3={}
                        for k_3,v_3 in c_3.items():
                            if k_3 != 'children':
                                o_3[k_3]=v_3
                            elif k_3 == 'children':
                                for c_4 in v_3:
                                    pass
#                         print('o_2',o_2)
                        out.append(o_3)
#             print('o_2',o_2)
            out.append(o_2)
out.append(o_1)
out

三、结果

[{'name': 'b4', 'id': 4, 'p_id': 2},
 {'name': 'b2', 'id': 2, 'p_id': 1},
 {'name': 'b5', 'id': 5, 'p_id': 3},
 {'name': 'b3', 'id': 3, 'p_id': 1},
 {'name': 'b1', 'id': 1, 'p_id': 0}]

四、转为dataframe格式

import pandas as pd
df = pd.DataFrame(out)
df = df.sort_values('id')
df