title: How to read json nested data with pandas
body: <p>I have Json data which have a combination of list and Dictionaries, particularly list within Dictionary and  vice versa.</p>
  <p>I am trying to parse this with <code>Pandas</code> and <code>Json</code> but not getting the right way to get it.</p>
  <p><strong>Json Data:</strong></p>
  <pre><code>{
    &quot;statusMessage&quot;: &quot;OK&quot;,
    &quot;statusCode&quot;: 200,
    &quot;response&quot;: {
      &quot;id&quot;: &quot;15076&quot;,
      &quot;name&quot;: &quot;NetApp525&quot;,
      &quot;startTime&quot;: 1626710400443,
      &quot;mounted&quot;: false,
      &quot;vmwareSnapshot&quot;: &quot;Yes&quot;,
      &quot;status&quot;: &quot;Completed&quot;,
      &quot;policy&quot;: &quot;BckupPolicy&quot;,
      &quot;entities&quot;: [
        {
          &quot;entityName&quot;: &quot;dbv6017_esx01&quot;,
          &quot;quiesced&quot;: false,
          &quot;uuid&quot;: &quot;netfs://dbv6017.example.com///virt/dbv6017_esx01&quot;,
          &quot;locations&quot;: [
            &quot;192.168.1.2:/vol/dbv6017_esx01&quot;
          ]
        },
        {
          &quot;entityName&quot;: &quot;backs6001.example.com&quot;,
          &quot;quiesced&quot;: true,
          &quot;uuid&quot;: &quot;5558878d-f26a-5018-3cef-cgfh7802a550&quot;,
          &quot;locations&quot;: [
            &quot;[dbv6017_esx01] backs6001.example.com/backs6001.example.com.vmx&quot;
          ]
        },
        {
          &quot;entityName&quot;: &quot;cpt6001&quot;,
          &quot;quiesced&quot;: true,
          &quot;uuid&quot;: &quot;500a1bcc-6757-b5b8-6888-e66a26df713c&quot;,
          &quot;locations&quot;: [
            &quot;[dbv6017_esx01] dnvt6001/dnvt6001.vmx&quot;
          ]
        },
        {
          &quot;entityName&quot;: &quot;cpt0254&quot;,
          &quot;quiesced&quot;: true,
          &quot;uuid&quot;: &quot;300a028f-68e8-0db8-8919-2trpc01a7dfb3&quot;,
          &quot;locations&quot;: [
            &quot;[dbv6017_esx01] cpt0254/cpt0254.vmx&quot;
          ]
        },
        {
          &quot;entityName&quot;: &quot;cpt6018&quot;,
          &quot;quiesced&quot;: true,
          &quot;uuid&quot;: &quot;500aa1bf-38b0-2e05-613b-c232ac0a36c3&quot;,
          &quot;locations&quot;: [
            &quot;[dbv6017_esx01] cpt6018/cpt6018.vmx&quot;
          ]
        }
      ]
    }
  }
  </code></pre>
  <p><strong>What I'm trying:</strong></p>
  <pre><code>import json
  import pandas as pd
  df = pd.read_json(&quot;my_json_data&quot;)
  
  print(df)
  
  
  &gt;&gt;&gt; df
                 statusMessage  statusCode  \
  entities                  OK         200
  id                        OK         200
  mounted                   OK         200
  name                      OK         200
  policy                    OK         200
  startTime                 OK         200
  status                    OK         200
  vmwareSnapshot            OK         200
  
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      response
  entities        [{'entityName': 'dbv6017_esx01', 'quiesced': False, 'uuid': 'netfs://dbv6017.example.com///virt/dbv6017_esx01', 'locations': ['192.168.1.2:/vol/dbv6017_esx01']}, {'entityName': 'backs6001.example.com', 'quiesced': True, 'uuid': '5558878d-f26a-5018-3cef-cgfh7802a550', 'locations': ['[dbv6017_esx01] backs6001.example.com/backs6001.example.com.vmx']}, {'entityName': 'cpt6001', 'quiesced': True, 'uuid': '500a1bcc-6757-b5b8-6888-e66a26df713c', 'locations': ['[dbv6017_esx01] dnvt6001/dnvt6001.vmx']}, {'entityName': 'cpt0254', 'quiesced': True, 'uuid': '300a028f-68e8-0db8-8919-2trpc01a7dfb3', 'locations': ['[dbv6017_esx01] cpt0254/cpt0254.vmx']}, {'entityName': 'cpt6018', 'quiesced': True, 'uuid': '500aa1bf-38b0-2e05-613b-c232ac0a36c3', 'locations': ['[dbv6017_esx01] cpt6018/cpt6018.vmx']}]
  id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     15076
  mounted                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                False
  name                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               NetApp525
  policy                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           BckupPolicy
  startTime                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      1626710400443
  status                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             Completed
  vmwareSnapshot                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           Yes
  </code></pre>
  <p><strong>Desired:</strong></p>
  <p>I want the Keys of column <code>response</code> to be converted as column and values remain with column then.</p>
  <pre><code>entityName                      quiesced   uuid                                     locations
  backs6001.example.com           TRue    5558878d-f26a-5018-3cef-cgfh7802a550        dbv6017_esx01
  </code></pre>