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

Question

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)

Wai Ha Lee · Accepted Answer · 2021-08-24 20:37:15Z

2

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)

edited Aug 24, 2021 at 20:37

Wai Ha Lee

8,856102 gold badges61 silver badges100 bronze badges

answered Aug 24, 2021 at 12:35

dtc348

3647 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Nish Over a year ago

Thanks for this, in return I receive the following error ` Expecting value: line 1 column 1 (char 0)`

dtc348 Over a year ago

Hey, from my side looks all good and code is working. May be from your side, you need to check requests or pandas lib.

Nish Over a year ago

That's interesting, everything seems fine here too, it may be a deeper issue, I will look into it, thank you!

Collectives™ on Stack Overflow

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

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related