title: Multiple keys defined in record_path not working when using json_normalize function of pandas
body: <p>I have a json value in where two keys are of <code>List</code> type inside main data point.</p>
  <pre class="lang-json prettyprint-override"><code>[
    {
      &quot;org_id&quot;: 1,
      &quot;org_name&quot;: &quot;Test&quot;,
      &quot;super_admin&quot;: [],
      &quot;sub_admin&quot;: []
    },
    {
      &quot;org_id&quot;: 2,
      &quot;org_name&quot;: &quot;QA&quot;,
      &quot;super_admin&quot;: [
        {
          &quot;id&quot;: 1,
          &quot;first_name&quot;: &quot;User&quot;,
          &quot;last_name&quot;: null,
          &quot;email&quot;: &quot;qw@qw.com&quot;,
          &quot;phone&quot;: null
        },
        {
          &quot;id&quot;: 2,
          &quot;first_name&quot;: &quot;Test&quot;,
          &quot;last_name&quot;: &quot;User&quot;,
          &quot;email&quot;: &quot;asd@qw.com&quot;,
          &quot;phone&quot;: null
        }
      ],
      &quot;sub_admin&quot;: [
        {
          &quot;id&quot;: 3,
          &quot;first_name&quot;: &quot;pd&quot;,
          &quot;last_name&quot;: null,
          &quot;email&quot;: &quot;rt@rt,com&quot;,
          &quot;phone&quot;: null
        }
      ]
    },
    {
      &quot;org_id&quot;: 3,
      &quot;org_name&quot;: &quot;My test Org&quot;,
      &quot;super_admin&quot;: [],
      &quot;sub_admin&quot;: []
    },
    {
      &quot;org_id&quot;: 4,
      &quot;org_name&quot;: &quot;test Org&quot;,
      &quot;super_admin&quot;: [],
      &quot;sub_admin&quot;: []
    }
  ]
  </code></pre>
  <p>When I am trying to Normalize this using pandas as</p>
  <pre class="lang-py prettyprint-override"><code>df = pd.json_normalize(arr, meta=['org_name', 'org_id',], record_path=['super_admin', 'sub_admin', ],   errors='ignore')
  </code></pre>
  <p>It raises an error <code>KeyError: &quot;Key 'sub_admin' not found. If specifying a record_path, all elements of data should have the path.&quot;</code></p>
  <p>But if only one key is defined in record_path like <code>pd.json_normalize(arr, meta=['org_name', 'org_id',], record_path=['super_admin', ],   errors='ignore')</code> then everything is working fine.</p>
  <p>Initially, I thought It might be due to same keys in both super_admin &amp; sub_admin but even with different keys json_normalize was raising same error.</p>
  <p>I can merge both lists super_admin &amp; sub_admin and create one list and use that in the record list but then I won't be able to separate in the final result which one is super admin and which one is sub admin value.</p>