Menu
Article Troubleshooting

python requests json to dataframe

Narkw Brahma

Narkw Brahma

• 1 min read

Python Requests JSON to DataFrame

If you are working with Python and want to convert JSON data received through an API request to a DataFrame, then you can use the pandas library. It is a powerful library for data manipulation and analysis. Here are the steps you can follow:

  1. Send a GET request to the API endpoint using the requests library. The response will be in JSON format.
  2. Create a DataFrame using the JSON data.

Code

Here's an example code snippet:


import requests
import pandas as pd

url = 'https://example.com/api/data'
response = requests.get(url)

data = response.json()
df = pd.DataFrame(data)

In this example, we are sending a GET request to the URL 'https://example.com/api/data' and storing the response in a variable called 'response'. We then convert the response to JSON format using the '.json()' method and store it in a variable called 'data'. Finally, we create a DataFrame using the 'pd.DataFrame()' method and pass in the 'data' variable.

Multiple Ways

There are other ways to achieve the same result. One of them is by using the 'json_normalize' function from pandas:


import requests
import pandas as pd

url = 'https://example.com/api/data'
response = requests.get(url)

data = response.json()
df = pd.json_normalize(data)

The 'json_normalize' function takes a nested JSON object and flattens it into a DataFrame.

Share