Pandas -将数据从一列拆分为多列

我有一个以下格式的Dataframe：

id, data
101, [{"tree":[
               {"Group":"1001","sub-group":3,"Child":"100267","Child_1":"8 cm"},
               {"Group":"1002","sub-group":1,"Child":"102280","Child_1":"4 cm"},
               {"Group":"1003","sub-group":0,"Child":"102579","Child_1":"0.1 cm"}]}]
102, [{"tree":[
               {"Group":"2001","sub-group":3,"Child":"200267","Child_1":"6 cm"},
               {"Group":"2002","sub-group":1,"Child":"202280","Child_1":"4 cm"}]}]
103,

我正在尝试将这一列中的数据拆分为多列

预期输出：

id, Group, sub-group, Child, Child_1, Group, sub-group, Child, Child_1, Group, sub-group, Child, Child_1
101, 1001, 3, 100267, 8 cm, 1002, 1, 102280, 4 cm, 1003, 0, 102579, 0.1 cm
102, 2001, 3, 200267, 6 cm, 2002, 1, 2022280, 4 cm
103

df.loc[:15, ['id','data']].to_dict()的输出

{'id': {1: '101',
        4: '102',
        11: '103',
        15: '104',
        16: '105'},
        'data': {1: '[{"tree":[{"Group":"","sub-group":"3","Child":"100267","Child_1":"8 cm"}]}]',
        4: '[{"tree":[{"sub-group":"0.01","Child_1":"4 cm"}]}]',
        11: '[{"tree":[{"sub-group":null,"Child_1":null}]}]',
        15: '[{"tree":[{"Group":"1003","sub-group":15,"Child":"child_","Child_1":"41 cm"}]}]',
        16: '[{"tree":[{"sub-group":"0.00","Child_1":"0"}]}]'}}

转载请注明出处:http://www.jubohx.com/article/20230502/1858537.html