JSON from API call to pandas dataframe

Question

I'm trying to get an API call and save it as a dataframe. problem is that I need the data from the 'result' column. Didn't succeed to do that.

I'm basically just trying to save the API call as a csv file in order to work with it.

P.S when I do this with a "JSON to CSV converter" from the web it does it as I wish. (example: https://konklone.io/json/)

import requests
import pandas as pd
import json

res = requests.get("http://api.etherscan.io/api?module=account&action=txlist&
address=0xddbd2b932c763ba5b1b7ae3b362eac3e8d40121a&startblock=0&
endblock=99999999&sort=asc&apikey=YourApiKeyToken")

j = res.json()

j

df = pd.DataFrame(j)

df.head()

output example picture

good question, had the same issue

Or Bachar
– Or Bachar

2018-04-01 12:27:11 +00:00
Commented Apr 1, 2018 at 12:27 — Or Bachar
– Or Bachar, Commented Apr 1, 2018 at 12:27

Hayat · Accepted Answer · 2018-03-21 15:54:16Z

1

Try this

import requests
import pandas as pd
import json

res = requests.get("http://api.etherscan.io/api?module=account&action=txlist&address=0xddbd2b932c763ba5b1b7ae3b362eac3e8d40121a&startblock=0&endblock=99999999&sort=asc&apikey=YourApiKeyToken")

j = res.json()

# print(j)
filename ="temp.csv"
df = pd.DataFrame(j['result'])

print(df.head())
df.to_csv(filename)

answered Mar 21, 2018 at 15:54

Hayat

1,6494 gold badges22 silver badges32 bronze badges

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

Comments

Rakesh · Accepted Answer · 2018-03-21 15:44:36Z

1

Looks like you need.

df = pd.DataFrame(j["result"])

answered Mar 21, 2018 at 15:44

Rakesh

82.9k17 gold badges85 silver badges122 bronze badges

Collectives™ on Stack Overflow

JSON from API call to pandas dataframe

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related