title: Extracting values for a specific key-value pair in Pandas Dataframe
body: <p>I have a Dataframe for whom one of the columns has a list of nested dicts. I am trying to fetch value pertaining to a specific key.</p>
  
  <p>Given below is how the Dataframe looks like:</p>
  
  <pre><code>sale_id, sale_detail
  10001, [{
           'compulsory_on_complete': True,
           'name': 'Store Location',  &lt;-- Pull value corresponding to this as given in the next row
           'value': 'London',   
           'value_id': 2}, 
          {
           'compulsory_on_complete': True,
           'name': 'Product Category', &lt;-- Pull value corresponding to this as given in the next row
           'value': 'General',
           'value_id': 5}] 
  10002, [{
           'compulsory_on_complete': True,
           'name': 'Store Location',
           'value': 'Scotland',
           'value_id': 2}, 
          {
           'compulsory_on_complete': True,
           'name': 'Product Category',
           'value': 'Supplies',
           'value_id': 5}] 
  </code></pre>
  
  <p>Expected output:</p>
  
  <pre><code>sale_id, store_location, product_category
  10001, London, General
  10002, Scotland, Supplies
  </code></pre>