Convert Multiple Nested JSON to Pandas Dataframe

Question

Here's the response I get from my stock data API provider:

    {'status': {'code': 0, 'message': ''},
 'data': {'symbol': 'ESHRAQ',
  'company': 'Eshraq properties Co.',
  'exchange': 'ABU_DHABI',
  'prices': {'columns': ['date', 'open', 'high', 'low', 'close', 'volume'],
   'values': [['2021-12-16T10:00:00Z', 0.39, 0.39, 0.39, 0.39, 4140513],
    ['2021-12-19T10:00:00Z', 0.0, 0.0, 0.35, 0.38, 19006953]]}}}

I need the results to be a simple Pandas dataframe with the following columns: date, company, open, high, low, close, volume.

user17242583 · Accepted Answer · 2021-12-19 17:38:59Z

2

d = your_json['data']
df = pd.DataFrame(d['prices']['values'], columns=d['prices']['columns']).assign(company=d['company'])

Output:

>>> df
                   date  open  high   low close    volume                company
0  2021-12-16T10:00:00Z  0.39  0.39  0.39  0.39   4140513  Eshraq properties Co.
1  2021-12-19T10:00:00Z  0.00  0.00  0.35  0.38  19006953  Eshraq properties Co.

answered Dec 19, 2021 at 17:38

user17242583

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert Multiple Nested JSON to Pandas Dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related