Python Answers

How to convert JSON to a Python Pandas DataFrame?

Spread the love

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.

By John Au-Yeung

Web developer specializing in React, Vue, and front end development.

Leave a Reply

Your email address will not be published. Required fields are marked *