title: Pandas - Splitting data from one column into multiple columns
body: <p>I have a Dataframe in the below format:</p>
  
  <pre><code>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,  
  </code></pre>
  
  <p>I am trying to have data from this one column split into multiple columns</p>
  
  <p>Expected output:</p>
  
  <pre><code>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
  </code></pre>
  
  <p>Output of <code>df.loc[:15, ['id','data']].to_dict()</code></p>
  
  <pre><code>{'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"}]}]'}}
  </code></pre>