How to extract data from Json to Pandas dataFrame?

S

s19s932021-08-10 16:00:27

Python

s19s93, 2021-08-10 16:00:27

Good afternoon !
Tell me how to convert data from a Json file to a DataFrame using pandas?

from pandas.io.json import json_normalize
import pandas as pd
import json


df = pd.read_json('https://api.bittrex.com/api/v1.1/public/getmarketsummary?market=USD-BTC')
df = pd.json_normalize(df)
print(df)

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

Z

zexer, 2021-08-10
@zexer

Depending on the form in which your data is in JSON, show an example.

S

s19s93, 2021-08-10
@s19s93

https://api.bittrex.com/api/v1.1/public/getmarkets...
can be viewed from this api