read_json returns empty dataframe using pandas.read_json

Question

i'm running this code but the api stopped to send bets values, how can i dataframe the "vazio" to scrappe values inside?

vazio='https://api-v2.blaze.com/roulette_games/current'
    
urlData = requests.get(vazio).content
rodadaatual = pd.read_json(io.StringIO(urlData.decode('utf-8')))

output

Empty DataFrame
Columns: [id, color, roll, created_at, updated_at, status, total_red_eur_bet, total_red_bets_placed, total_white_eur_bet, total_white_bets_placed, total_black_eur_bet, total_black_bets_placed, bets]
Index: []

how are we supposed to guess what a request to a random API will output? — mozway
– mozway, Commented Jul 12, 2022 at 13:13
I think he wants an empty dataframe with a column index of the keys of the json response. Vazio mean empty in portuguese so i am guessing here — INGl0R1AM0R1
– INGl0R1AM0R1, Commented Jul 12, 2022 at 13:14
yes, i want the data on this link, but he returning a empty Dataframe — Lucas Mendes
– Lucas Mendes, Commented Jul 12, 2022 at 13:22
Hi @LucasMendes can you try my answer and let me know if it helps. If it does please consider accepting the answer by clicking on check symbol left of the answer box — Himanshu Poddar
– Himanshu Poddar, Commented Jul 16, 2022 at 19:05
Hey @LucasMendes, can you atleast confirm if answer worked for you or not — Himanshu Poddar
– Himanshu Poddar, Commented Jul 19, 2022 at 9:43

Himanshu Poddar · Accepted Answer · 2022-07-12 14:04:47Z

1

You need to provide the data you read in a valid json list format. Then you can use pandas.read_json to read the json data

urlData = '[' + urlData.decode('utf-8') + ']'
pd.read_json(urlData)

Output :

This gives us the desired dataframe

           id  color  roll  ... total_black_eur_bet total_black_bets_placed bets
0  BylLAX00rG    NaN   NaN  ...                   0                       0   []

[1 rows x 13 columns]

answered Jul 12, 2022 at 14:04

Himanshu Poddar

7,90116 gold badges60 silver badges120 bronze badges

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

Collectives™ on Stack Overflow

read_json returns empty dataframe using pandas.read_json

1 Answer 1

Output :

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Output :

Comments

Your Answer

Sign up or log in

Post as a guest

Related