title: Extract a value from the given data set in python
body: <p>I am using below is my code and output</p>
  <pre><code> test2 = json.loads(test)
  
  
  [
  {
      &quot;cert&quot;: {
          &quot;alternate_names&quot;: [
              &quot;XXX&quot;,
              &quot;YYY&quot;
          ],
          &quot;common_name&quot;: &quot;aaa&quot;,
          &quot;created_on&quot;: &quot;1111&quot;,
          &quot;status&quot;: &quot;Expired&quot;,
          &quot;subject&quot;: test,
          &quot;valid_from&quot;: &quot;2018-04-15T00:00:00.0000000Z&quot;,
          &quot;valid_to&quot;: &quot;2020-04-14T23:59:59.0000000Z&quot;
      },
      &quot;meta&quot;: {
          
          &quot;asset_name&quot;: &quot;&quot;,
          &quot;audience&quot;: &quot;External&quot;,
          &quot;automation_utility&quot;: &quot;&quot;,
          &quot;delegate_owner&quot;: &quot;&quot;,
          &quot;environment&quot;: dev
          &quot;l2_group_email&quot;: null,
          &quot;l3_group_email&quot;: null,
          &quot;requestor_email&quot;: &quot;&quot;,
          &quot;support_email&quot;: &quot;&quot;,
          &quot;tech_delegate_email&quot;: null,
          &quot;tech_owner_email&quot;: null
      }
  }
    ]
  </code></pre>
  <p>I want to extract the status field and other fields from the data and append it to a pandas data frame as columns and export it to excel file .</p>
  <pre><code> df['output']= df['Serial Number'].apply(lambda x:fetch_by_ser_no(x))
  </code></pre>
  <p>Now I want to create different columns for common_name,alternate_names,status etc .</p>
  <p>being pretty new to python can some one please guide me through.</p>
  <p>Thanks</p>