title: Pandas read one parameter from nested json
body: <p>i have a following json file and i would like to read all the parameters: &quot;dataRecordId&quot; only and store them into a df:</p>
  <pre><code>{'responseInformation': '20 metadata records in response.',
   'metaDataResponse': [{'timestampFrom': '2020-10-07T10:19:07.7810000Z',
     'timestampTo': '2020-10-07T23:59:59.9999990Z',
     'component': {'type': '', 'id': '', 'name': '', 'comment': ''},
     'resource': {'type': 'EQU', 'id': '6100380', 'name': '', 'comment': ''},
     'processStep': {'type': '', 'id': '', 'name': '', 'comment': ''},
     'context': '',
     'dataRecords': [{'dataRecordId': '171533103',
       'groupName': 'Process',
       'sensorName': 'AutomaticProcessActive',
       'profile': 'sd',
       'type': 'Switch2Way',
       'unit': 'state',
       'returnType': 'timeSeries'}]},
    {'timestampFrom': '2020-10-08T00:00:00.6540000Z',
     'timestampTo': '2020-10-08T23:59:59.9999990Z',
     'component': {'type': '', 'id': '', 'name': '', 'comment': ''},
     'resource': {'type': 'EQU', 'id': '6100380', 'name': '', 'comment': ''},
     'processStep': {'type': '', 'id': '', 'name': '', 'comment': ''},
     'context': '',
     'dataRecords': [{'dataRecordId': '171534669',
       'groupName': 'Process',
       'sensorName': 'AutomaticProcessActive',
       'profile': 'sd',
       'type': 'Switch2Way',
       'unit': 'state',
       'returnType': 'timeSeries'}]},
  </code></pre>
  <p>This is what i did so far, but i have no idea how to go deeper in the structure, in order to achieve the 'dataRecordId':</p>
  <pre><code>import json
  
  with open('file_200826_201026.json') as json_file:
      data = json.load(json_file)
  
      for p in data['metaDataResponse']:
          print('p['dataRecords'])
  </code></pre>