title: Separate JSON elements into columns of pandas dataframe
body: <p>I'm trying to separate elements from a list into different columns of a pandas dataframe. Essentially I want, for every <code>tenure</code> option - i.e. Detached, Semi-detached, columns like <code>detached_price</code>, <code>detached_cost</code>, <code>detached_rooms</code> and <code>detached_asking</code>, then the same for Semi-detached, Terraced, Flats etc. </p>
  
  <pre><code>p = [{'br8': [{'tenure': 'Detached',
      'data': ['£1,248,554', '£571', '4.3', '£1,063,001']},
     {'tenure': 'Semi-detached',
      'data': ['£581,968', '£499', '3.3', '£587,188']},
     {'tenure': 'Terraced', 'data': ['£520,725', '£516', '3.0', '£474,719']},
     {'tenure': 'Flats', 'data': ['£424,898', '£516', '2.0', '£394,092']}]}]
  </code></pre>
  
  <p>I've tried this so far, but it won't parse the columns correctly. Does anybody have any advice or direction as to how to achieve my goal here?</p>
  
  <p><code>pd.DataFrame.from_records(p).T</code></p>
  
  <p>My desired output is:</p>
  
  <pre><code>     detached_price, detached_cost, detached_rooms, detached_asking, semi_detached_price, etc etc
  br8  £1,248,554,    £571 ,          4.3 ,            £1,063,001,     £581,968
  </code></pre>