CODEWITHSUNDEEP
pythonpandas
Nish
Nish

Reputation: 63

How to convert json text string into a pandas dataframe from API request?

trivial question here but how can I convert my api request data into a pandas df

I can only view the data by doing print(response1.text) I'd like it as a dataframe

url = "https://alpha-vantage.p.rapidapi.com/query"
querystring = {"interval":"1min","function":"TIME_SERIES_INTRADAY_EXTENDED","symbol":"GME","datatype":"json","slice":'year1month8'}
headers = {
    'x-rapidapi-host': "alpha-vantage.p.rapidapi.com",
    'x-rapidapi-key': "(omitted)"
    }
response1 = requests.request("GET", url, headers=headers, params=querystring)

Upvotes: 0

Views: 126

Answers (1)

dtc348
dtc348

Reputation: 364

import requests
import pandas as pd    
url = "https://alpha-vantage.p.rapidapi.com/query"
querystring = {"interval":"1min","function":"TIME_SERIES_INTRADAY_EXTENDED","symbol":"GME","datatype":"json","slice":'year1month8'}
headers = {
    'x-rapidapi-host': "alpha-vantage.p.rapidapi.com",
    'x-rapidapi-key': "(omitted)"
    }
response1 = requests.request("GET", url, headers=headers, params=querystring)

response1_json = response1.json()
df = pd.json_normalize(response1_json)

print(df)

Upvotes: 2

Related Questions