title: python: Pandas - Convert complex json to a dataframe
body: <p>I have a complex JSON data structure and have to convert it to a data frame. The JSON structure is as follows:</p>
  
  <pre><code>{'fields': [{'id': 'a', 'label': 'Particulars', 'type': 'string'},
    {'id': 'b', 'label': 'States', 'type': 'string'},
    {'id': 'c', 'label': 'Gender', 'type': 'string'},
    {'id': 'd', 'label': ' 11-2013', 'type': 'string'},
    {'id': 'e', 'label': ' 12-2013', 'type': 'string'},
    {'id': 'f', 'label': ' 1-2014', 'type': 'string'},
    {'id': 'g', 'label': ' 2-2014', 'type': 'string'}],
   'data': [['Animal Husbandry- incl Poultry, Dairy and Herdsman',
     'Andhra Pradesh',
     'Men',
     '156.12',
     '153.18',
     '163.56',
     '163.56'],
    ['Animal Husbandry- incl Poultry, Dairy and Herdsman',
     'Bihar',
     'Men',
     '159.39',
     '149.38',
     '147.24',
     '155.89'],
    ['Animal Husbandry- incl Poultry, Dairy and Herdsman',
     'Gujarat',
     'Men',
     '157.08',
     '145',
     '145',
     '145']]}
  </code></pre>
  
  <p>I want to make a dataframe from it in the following format:</p>
  
  <p><a href="https://i.stack.imgur.com/6QqSj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6QqSj.png" alt="Dataframe"></a></p>
  
  <p>I tried directly using the <code>read_json</code> function which gives me error. Then I tried using <code>json.normalize</code> which does not give me the desired output as I don't know its proper working. Can anyone let me know how should I use <code>json.normalize()</code> to get the output in my required format?</p>