title: how to convert python dictionary into required data frame output?
body: <p>lets say I am getting api response as</p>
  <pre><code>response= {
  'id': {'abc':[{'area_code':'mkt','area_name':'market'},{'area_code':'chdi','area_name':'chandani'}],
  {'xyz':[{'area_code':'rlr','area_name':'rural'},{'area_code':'rwl_st','area_name':'railway station'}]}
  }}
  </code></pre>
  <p>I wanted to convert it to data frame as (expected output as)</p>
  <p><a href="https://i.stack.imgur.com/HOIXw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HOIXw.png" alt="enter image description here" /></a></p>
  <p>my effort :<code>pd.json_normalize(response).apply(pd.Series.explode)</code></p>
  <p>but it didn't work</p>