title: Python Flatten Multiply Nested Dictionary JSON with Pandas
body: <p>I am working with a JSON response that is formatted like a many-nested dictionary below:</p>
  
  <pre><code>{u'addresses': [],
   u'application_ids': [20855193],
   u'applications': [{u'answers': [{u'answer': u'Indeed ',
                                    u'question': u'How did you hear?'}],
                      u'applied_at': u'2015-10-29T22:19:04.925Z',
                      u'candidate_id': 9999999,
                      u'credited_to': None,
                      u'current_stage': {u'id': 9999999,
                                         u'name': u'Application Review'},
                      u'id': 9999999,
                      u'jobs': [{u'id': 9999999,u'name': u'ENGINEER'}],
                      u'last_activity_at': u'2015-10-29T22:19:04.767Z',
                      u'prospect': False,
                      u'rejected_at': None,
                      u'rejection_details': None,
                      u'rejection_reason': None,
                      u'source': {u'id': 7, u'public_name': u'Indeed'},
                      u'status': u'active'}],
   u'attachments': [{u'filename': u'Jason_Bourne.pdf',
                     u'type': u'resume',
                     u'url': u'https://resumeURL'}],
   u'company': None,
   u'coordinator': {u'employee_id': None,
                    u'id': 9999999,
                    u'name': u'Batman_Robin'},
   u'email_addresses': [{u'type': u'personal',
                         u'value': u'jasonbourne@gmail.com'}],
   u'first_name': u'Jason',
   u'id': 9999999,
   u'last_activity': u'2015-10-29T22:19:04.767Z',
   u'last_name': u'Bourne',
   u'website_addresses': []}
  </code></pre>
  
  <p>I am trying to flatten the JSON into a table and have found the following example on the pandas documentation:</p>
  
  <p><a href="http://pandas.pydata.org/pandas-docs/version/0.17.0/generated/pandas.io.json.json_normalize.html" rel="nofollow noreferrer">http://pandas.pydata.org/pandas-docs/version/0.17.0/generated/pandas.io.json.json_normalize.html</a></p>
  
  <p>From what I understand, the "record_path" parameter specifies the path of the lowest-level record you are interested in. The "record_path" parameter can only be a string, or list of strings. But, to call the 'answers' records in my data above, I have to specify strings <strong>and</strong> indexes as follows;</p>
  
  <pre><code>answer = data['applications'][0]['answers']['answer']
  question = data['applications'][0]['answers']['question']
  </code></pre>
  
  <p>How can I enter the record paths above as a parameter to the json_normalize function?</p>
  
  <p>Thanks!</p>