title: Json to Pandas, include "Parents"
body: <p>With a list of 150+ Neighborhoods , I am using Foursquare API to retrieve nearby <code>venues</code> at 500m radius of a given Neighbourhood. Each Neighbourhood is expected to return 10-20 nearby <code>venues</code>.</p>
  <p>Refer to snippet of json result as returned by Foursquare.</p>
  <p>With <code>results['response']['groups'][0]['items']</code>, I able to retrieve the nearby <code>venues</code> information and make it a Table as below. However <code>results['response']['groups'][0]['items']</code> does not have the Neighbourhood ( under <code>headerFullLocation</code> in json) of  associated <code>venues</code>.</p>
  <p><strong><strong>Q: How can I link the Neighbourhood(<code>headerFullLocation</code>) to its associated nearby <code>venue</code> and add it as a column to table below?</strong> Thanks for the advice.</strong></p>
  <p><a href="https://i.stack.imgur.com/hEsGB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hEsGB.png" alt="enter image description here" /></a></p>
  <pre><code>{'suggestedFilters': {'header': 'Tap to show:',
    'filters': [{'name': 'Open now', 'key': 'openNow'}]},
   'headerLocation': 'Alexandra Park',
   'headerFullLocation': 'Alexandra Park, Toronto',**
   'headerLocationGranularity': 'neighborhood',
   'totalResults': 138,
   'suggestedBounds': {'ne': {'lat': 43.6545000045, 'lng': -79.39379244047241},
    'sw': {'lat': 43.645499995499996, 'lng': -79.4062075595276}},
   'groups': [{'type': 'Recommended Places',
     'name': 'recommended',
     'items': [{'reasons': {'count': 0,
        'items': [{'summary': 'This spot is popular',
          'type': 'general',
          'reasonName': 'globalInteractionReason'}]},
       'venue': {'id': '5644dbaa498e7f7534154326',
        '**name': 'Maker Pizza',**
        'contact': {},
        'location': {'address': '59 Cameron St',
         'lat': 43.6504011331197,
         'lng': -79.39804047841302,
         'labeledLatLngs': [{'label': 'display',
           'lat': 43.6504011331197,
           'lng': -79.39804047841302}],
         'distance': 164,
         'postalCode': 'M5T 2H1',
         'cc': 'CA',
         'city': 'Toronto',
         'state': 'ON',
         'country': 'Canada',
         'formattedAddress': ['59 Cameron St', 'Toronto ON M5T 2H1', 'Canada']},
        'categories': [{'id': '4bf58dd8d48988d1ca941735',
          'name': 'Pizza Place',
          'pluralName': 'Pizza Places',
          'shortName': 'Pizza',
          'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/pizza_',
           'suffix': '.png'},
          'primary': True}],
        'verified': False,
        'stats': {'tipCount': 0,
         'usersCount': 0,
         'checkinsCount': 0,
         'visitsCount': 0},
        'beenHere': {'count': 0,
         'lastCheckinExpiredAt': 0,
         'marked': False,
         'unconfirmedCount': 0},
        'photos': {'count': 0, 'groups': []},
        'hereNow': {'count': 0, 'summary': 'Nobody here', 'groups': []}},
  </code></pre>