I'm trying to get all the data out of an API call which is returned in the json format.

For this purpose I'm using the json_normalize library from pandas, but I'm left with a list within that list that is not unwrapped.

This is the code I am using:

data=requests.get(url,endpointParams)
data_read=json.loads(data.content)
values=json_normalize(data_read['data'])

This is what I end up with:

My question is how do I unwrap the values column?

EDIT: Here's the data_read before normalizing:

{'data': [{'name': 'follower_count',
   'period': 'day',
   'values': [{'value': 50, 'end_time': '2022-03-27T07:00:00 0000'},
    {'value': 50, 'end_time': '2022-03-28T07:00:00 0000'}],
   'title': 'Follower Count',
   'description': 'Total number of unique accounts following this profile',
   'id': '1/insights/follower_count/day'},
  {'name': 'impressions',
   'period': 'day',
   'values': [{'value': 19000, 'end_time': '2022-03-27T07:00:00 0000'},
    {'value': 6000, 'end_time': '2022-03-28T07:00:00 0000'}],
   'title': 'Impressions',
   'description': "Total number of times the Business Account's media objects have been viewed",
   'id': '1/insights/impressions/day'},
  {'name': 'profile_views',
   'period': 'day',
   'values': [{'value': 90, 'end_time': '2022-03-27T07:00:00 0000'},
    {'value': 99, 'end_time': '2022-03-28T07:00:00 0000'}],
   'title': 'Profile Views',
   'description': "Total number of users who have viewed the Business Account's profile within the specified period",
   'id': '1/insights/profile_views/day'},
  {'name': 'reach',
   'period': 'day',
   'values': [{'value': 5000, 'end_time': '2022-03-27T07:00:00 0000'},
    {'value': 2000, 'end_time': '2022-03-28T07:00:00 0000'}],
   'title': 'Reach',
   'description': "Total number of times the Business Account's media objects have been uniquely viewed",
   'id': '1/insights/reach/day'}],
 'paging': {'previous': 'someotherurl.com',
  'next': 'someurl.com'}}

CodePudding user response：

Try:

metadata = ['name', 'period', 'title', 'description', 'id']
out = pd.json_normalize(data_read['data'], 'values', metadata)