How to convert nested JSON data from a URL into a Pandas dataframe [duplicate]

Question

import json
import pandas
import requests

Convert to Pandas

I know what you're going to say, this has been asked before. But ive gone through a number of posts already and they all require importing the json file into the code already. So with this code I've been trying to import the json data through a URL, so there is no need to save any files before hand.

Is it even possible? Please help.

There is a way to achieve json to csv transformation through pandas - pandas.pydata.org/pandas-docs/stable/reference/api/… — Cavin Dsouza
– Cavin Dsouza, Commented Jun 22, 2021 at 22:29

sitting_duck · Accepted Answer · 2021-06-22 22:33:36Z

1

Pandas json_normalize can do just that. Here is an example for which you will have to modify to meet your specific needs:

df = pd.json_normalize(packages_json, record_path='results')

(I omitted the output from the DF because is it unwieldy)

answered Jun 22, 2021 at 22:33

sitting_duck

3,7801 gold badge17 silver badges20 bronze badges

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

2 Comments

TwoTimer Over a year ago

wow thank you, its workin! right now not all the headers (rows and columns) are being shown, but i assume there is a way to adjust that

sitting_duck Over a year ago

@Craig Play around with the meta parameter to access more fields.

Collectives™ on Stack Overflow

How to convert nested JSON data from a URL into a Pandas dataframe [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related