Menu Close

How to convert JSON to a Python Pandas DataFrame?

To convert JSON to a Python Pandas DataFrame, we can use the json.loads and json.normalize method.

For instance, we write

from urllib2 import Request, urlopen
import json

import pandas as pd    

path1 = '52.974049,-81.205203|52.974298,-81.195755'
response = urlopen(request)
elevations =
data = json.loads(elevations)
df = pd.json_normalize(data['results'])

to get some JSON data from request.

Then we call to read the JSON response into JSON.

Next, we call json.loads to load the JSON data into a dictionary.

And then we call Pandas json_normalize to load the values we want into a Pandas dataframe.

Posted in Python, Python Answers