title: how to normalize this below json using panda in django
body: <p><a href="https://i.stack.imgur.com/kxRqT.png" rel="nofollow noreferrer">using this view.py query my output is showing something like this. you can see in choices field there are multiple array so i can normalize in serial wise</a> <strong>here is my json</strong></p>
  <pre><code>{&quot;pages&quot;:[{&quot;name&quot;:&quot;page1&quot;,&quot;title&quot;:&quot;SurveyWindow Pvt. Ltd. Customer Feedback&quot;,&quot;description&quot;:&quot;Question marked * are compulsory.&quot;,
      &quot;elements&quot;:[{&quot;type&quot;:&quot;radiogroup&quot;,&quot;name&quot;:&quot;question1&quot;,&quot;title&quot;:&quot;Do you like our product? *&quot;,&quot;isRequired&quot;:true,
          &quot;choices&quot;:[{&quot;value&quot;:&quot;Yes&quot;,&quot;text&quot;:&quot;Yes&quot;},{&quot;value&quot;:&quot;No&quot;,&quot;text&quot;:&quot;No&quot;}]},{&quot;type&quot;:&quot;checkbox&quot;,&quot;name&quot;:&quot;question2&quot;,&quot;title&quot;:&quot;Please Rate Our PM Skill&quot;,&quot;isRequired&quot;:false,&quot;choices&quot;:[{&quot;value&quot;:&quot;High&quot;,&quot;text&quot;:&quot;High&quot;},{&quot;value&quot;:&quot;Low&quot;,&quot;text&quot;:&quot;Low&quot;},{&quot;value&quot;:&quot;Medium&quot;,&quot;text&quot;:&quot;Medium&quot;}]},{&quot;type&quot;:&quot;radiogroup&quot;,&quot;name&quot;:&quot;question3&quot;,&quot;title&quot;:&quot;Do you like our services? *&quot;,&quot;isRequired&quot;:true,&quot;choices&quot;:[{&quot;value&quot;:&quot;Yes&quot;,&quot;text&quot;:&quot;Yes&quot;},{&quot;value&quot;:&quot;No&quot;,&quot;text&quot;:&quot;No&quot;}]}]}]}
  </code></pre>
  <p><strong>this is my view.py</strong></p>
  <pre><code>    jsondata=SurveyMaster.objects.all().filter(survey_id='1H2711202014572740')
      q = jsondata.values('survey_json_design')
      qs_json = pd.DataFrame.from_records(q)
      datatotable = pd.json_normalize(qs_json['survey_json_design'], record_path=['pages','elements'])
      qs_json = datatotable.to_html()  
  </code></pre>