How to extract data from an api using python and convert it into a pandas data frame-CodePudding

I want to load the data from an API into a pandas data frame. How may I do that? The following is my code snippet:

import requests
import json
response_API = requests.get('https://data.spiceai.io/eth/v0.1/gasfees?period=1d')
#print(response_API.status_code)
data = response_API.text
parse_json = json.loads(data)

CodePudding user response：

Almost there, the json is clean you can directly input it to a dataframe :

response_API = requests.get('https://data.spiceai.io/eth/v0.1/gasfees?period=1d')
data = response_API.json()
df = pd.DataFrame(data)