Converting JSON data from requests.get to a pandas DataFrame

Question

I am trying to convert a json payload with no keys into a Pandas Dataframe. Below is what I have now

import requests
import pandas as pd

r = requests.get("https://api.pro.coinbase.com/products/BTC-USD/candles")

df = pd.read_json(r.json()).columns = ["time", "low", "high", "open", "close", "volume"]

print(df)

The request returns a payload like this...

[
    [
        1613256660,
        47077.61,
        47103.32,
        47100,
        47084.96,
        1.6661533
    ],
    ...
]

Your code is correct but for some syntax errors - pd.DataFrame(r.json(), columns = ["time", "low", "high", "open", "close", "volume"]) will work — cs95
– cs95, Commented Feb 14, 2021 at 0:04

cs95 · Accepted Answer · 2021-02-14 00:06:29Z

2

pd.read_json is used to read JSON string data. In your case, requests.Response has already parsed the JSON and is returning a list of lists when you call response.json(). So it should be sufficient to pass the list structure to pd.DataFrame directly:

df = pd.DataFrame(response.json(), 
                  columns=["time", "low", "high", "open", "close", "volume"])

answered Feb 14, 2021 at 0:06

cs95

406k106 gold badges744 silver badges797 bronze badges

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

Collectives™ on Stack Overflow

Converting JSON data from requests.get to a pandas DataFrame

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related