title: Convert list of Dictionaries to a Dataframe
body: <p>I am facing a basic problem of converting a list of dictionaries obtained from parsing a column with text in json format. Below is the brief snapshot of data:</p>
  
  <pre><code>[{u'PAGE TYPE': u'used-serp.model.brand.city'},
   {u'BODY TYPE': u'MPV Cars',
    u'ENGINE CAPACITY': u'1461',
    u'FUEL TYPE': u' Diesel',
    u'MODEL NAME': u'Renault Lodgy',
    u'OEM NAME': u'Renault',
    u'PAGE TYPE': u'New-ModelPage.OverviewTab'},
   {u'PAGE TYPE': u'used-serp.brand.city'},
   {u'BODY TYPE': u'SUV Cars',
    u'ENGINE CAPACITY': u'2477',
    u'FUEL TYPE': u' Diesel',
    u'MODEL NAME': u'Mitsubishi Pajero',
    u'OEM NAME': u'Mitsubishi',
    u'PAGE TYPE': u'New-ModelPage.OverviewTab'},
   {u'BODY TYPE': u'Hatchback Cars',
    u'ENGINE CAPACITY': u'1198',
    u'FUEL TYPE': u' Petrol , Diesel',
    u'MODEL NAME': u'Volkswagen Polo',
    u'OEM NAME': u'Volkswagen',
    u'PAGE TYPE': u'New-ModelPage.GalleryTab'},
  </code></pre>
  
  <p>Furthermore, the code i am using to parse is detailed below:</p>
  
  <pre><code>stdf_noncookie = []
  stdf_noncookiejson = []
  
  for index, row in df_noncookie.iterrows():
      try:
          loop_data = json.loads(row['attributes'])
          stdf_noncookie.append(loop_data)
      except ValueError:
          loop_nondata = row['attributes']
          stdf_noncookiejson.append(loop_nondata)
  </code></pre>
  
  <p>stdf_noncookie is the list of dictionaries i am trying to convert into a pandas dataframe. 'attributes' is the column with text in json format. I have tried to get some learning from this <a href="https://stackoverflow.com/questions/20638006/convert-list-of-dictionaries-to-dataframe">link</a>, however this was not able to solve my problem. Any suggestion/tips for converting a list of dictionaries to panda dataframe will be helpful.</p>