title: Converting JSON response with various list of fields into Pandas dataframe
body: <p>I am downloading some data from BestBuy Products API using python's Requests library and I want to store them into pandas dataframe.</p>
  
  <p>Something like that:</p>
  
  <pre><code>results = requests.get(url1, 
                    params={'paramStuff'}, 
                    headers={'User-Agent': ua})
  products = json.loads(results.text)
  </code></pre>
  
  <p>A get a lot of various fields with service info, thus I aim only for specific field in JSON which I want:</p>
  
  <pre><code>products['products']
  </code></pre>
  
  <p>I have:</p>
  
  <pre><code>[{'details':[{'name': 'Name of Feature', 'value':'Value Of Feature'},
               {'name': 'Name of Other Feature', 'value':'Value Of Other 
                Feature'}, ...],
     'ProductId': 'Id Of Product 1',
     'Some Other Field': 'Some Other Field Value'},
   {same structure as above for other product}, {etc}]
  </code></pre>
  
  <p>So as you see it is something like a list of dictionaries which in turn contain lists of dictionaries themselves. To highlight - details dict can have various list of combinations of Name: Value (names are different across products as well).</p>
  
  <p>Any idea on how to approach such structure to get into dataframe with such format:</p>
  
  <pre><code>+-----------+-------------------+-------------------+-------------------+------------------+
  | ProductID | Name of Feature 1 | Name of Feature 2 | Name Of Feature 3 | Some Other Field |
  +-----------+-------------------+-------------------+-------------------+------------------+
  | Product 1 | Value             | NULL              | Value             | Value            |
  | Product 2 | NULL              | Value             | Value             | Value            |
  +-----------+-------------------+-------------------+-------------------+------------------+
  </code></pre>
  
  <p>So far I only managed to get to something like this:</p>
  
  <pre><code>+-----------+-----------------------------------------------------------------------------------------------------------------------------------+------------------+
  | ProductID |                                                              Details                                                              | Some Other Field |
  +-----------+-----------------------------------------------------------------------------------------------------------------------------------+------------------+
  | Product 1 | [{'name': 'Name of Feature', 'value':'Value Of Feature'},{'name': 'Name of Other Feature', 'value':'Value Of Other Feature'},...] | Value 1          |
  | Product 2 | [{'name': 'Name of Feature', 'value':'Value Of Feature'},{'name': 'Name of Other Feature', 'value':'Value Of Other Feature'},...] | Value 2          |
  +-----------+-----------------------------------------------------------------------------------------------------------------------------------+------------------+
  </code></pre>